I have a set of data in different rows and columns, however 1 lead name (in 1 cell only).
How do I sort this information - as the lead name is not in each row!
I'm trying to go down the route of copy, pasting in a 2nd sheet and sorting the list alphabetically (column 1), then use vlookups to populate the rest of the table. WHich I've succeeded for the 1st 3 columns (straight forward vlookups) how do I populate the rest of sheet 2?
Thanks,
Bookmarks