Hi, I have attached a spreadsheet which probably is intuitive as to what i want to do as it shows the raw data and how i want it to look.
I have rows of data, some with long strings of different contact info for an individual
I just want to split up the contact info into seperate rows for that individual.
i.e I might have a guy named bob smith with 2 sets of contact information in the row.
I want to split it up, so it shows bob smith and 1 set of contact info in one row. In the second row it should have bob smith and the second set of contact information.
It should be fairly simple just not sure how to do it.