2 rows of email addresses!
 

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)?


---
Message posted from http://www.ExcelForum.com/

2 rows of email addresses!
 

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