Convert row to column?

[its_my_dime]

How do I do the following:

I have a an email group - long list. When expanded, it is --last name,
first name (email);

It looks like: Adams, Sam (adams @ sam.com); Baker, George (baker @
george.com); etc.

I want to create a COLUMN in excel consisting of each name and email address
(they don't need to be separated - just one name and address per cell going
down the column in order). The unique separator would be the ; .

How do I do this? I've tried importing in various ways but they always end
up in one ROW which is not what I need.

Thank you.

 

[Bernard Liengme]

Not clear where this long list is - is it imported into Excel ?
If you have it in Excel 2003 and there are fewer than 256 items (or Excel
2007 with =< 16,384 items),
then you can use Data | Text to Columns to separate into columns (one person
& email) per cell
Then use Copy and Paste Special with Transpose specified to make into one
column
best wishes

 

[coj]

Not clear where this long list is - is it imported into Excel ?
If you have it in Excel 2003 and there are fewer than 256 items (or Excel
2007 with =< 16,384 items),
then you can use Data | Text to Columns to separate into columns (one person
& email) per cell
Then use Copy and Paste Special with Transpose specified to make into one
column
best wishes

It might be easiest to use a text editor or word processor to convert
the ";" to carriage returns first.

For example open it in word and do a search and replace changing the ;
to a ^p, then import this to Excel

 

[its_my_dime]

Thank you.

The "transpose" function is what really make it work. I didn't even know
about this feature!

Again, many thanks.

 

[Bernard Liengme]

Glad to have helped
best wishes

Thank you.

The "transpose" function is what really make it work. I didn't even know
about this feature!

Again, many thanks.