hey there
I need to convert a list into a new format.
In the current worksheet,
The first column i have a name and then the next 10 columns are the names the person referred. Some referred 2 names, some referred 10 names. I have 10,000 rows of this. I need to convert this into a 2 column worksheet where I have the name of the referrer in the first column and the name of the referred in the 2nd column. (And then I would now have multiple names in the first column.)
ie Terry David Lisa Jason
would be
Terry David
Terry Lisa
Terry Jason
thanks for your help
Bookmarks