I have lots of data that looks like this. It has two columns:
But I need it to look like this. One name per row, with the emails added as extra columns as required. There is an unknown number of emails for each name:
|Name||Email 1||Email 2||Email 3|
I have to do this for a huge spreadsheet with thousands of rows. So I cannot manually convert each of them using something like transpose. I need a bulk/batch/automated solution.
I know that VBA is a thing that exists, but I don't know how to code it. If that is the solution can you please give me some direction of what the code should look like?
Non-VBA solutions are also very welcome.