changing a database list

**thedragon** · 10-29-2011, 06:07 AM

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

**Domski** · 10-29-2011, 07:59 AM

Hi,

Here you go:

Please Login or Register  to view this content.

Dom

**thedragon** · 10-30-2011, 06:49 PM

thanks Dom.

worked a treat

**ConneXionLost** · 10-30-2011, 08:50 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save