Moving e-mail addresses from columns to rows

[John Sullivan]

I have about 200 e-mail addresses, one e-mail address in
each column. I need to move all of them to one column
vertically (one e-mail address per cell) as opposed to
all e-mails displayed horizontally, side-by-side in each
cell.

 

[Norman Harker]

Hi John!

Select the row of addresses
Edit > Copy
Select a cell with at least 200 empty cells below
Edit > Paste Special
Select Transpose
OK



--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Public Holidays Saturday: Bosnia-Herzegovina (Petrovdan); Canada,
Northern Ireland, and Eire (Orangemen's Day); Kiribati (Independence
Day); Malaysia (Birthday of the Yang di-Pertua Negi Pulau Pinang);
Miconesia (Micronesian Day); Mongolia (National Day); Sao Tome &
Principe (Independence Day).
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Carl]

test