Convert row to column?

  • Thread starter Thread starter its_my_dime
  • Start date Start date
I

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.
 
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
 
Bernard said:
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
Click to expand...

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
 
Thank you.

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

Again, many thanks.
 
Glad to have helped
best wishes
its_my_dime said:
Thank you.

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

Again, many thanks.
Click to expand...
 
Back
Top