2 rows of email addresses!

  • Thread starter Thread starter andycharger
  • Start date Start date
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)?
 
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
 
Back
Top