2 rows of email addresses!

A

andycharger

I have 2 rows of email addresses. Obviously I want to somehow get them
al into one column. Is there a simple way to go cycle though the cells
in the top 2 rows and copy the contents every time to a column in
another sheet or to just change the contents of a row (horizontal) into
a column(vertical)?
 
J

Jim

1. Select Data
2. Edit Copy
3. Select Destination
4. Edit Paste Special and choose Transpose (Changes rows to columns and vice versa)

HTH,

Jim
 
Top