tranfer data from many columns to rows

Ms office / Excel7
September 16, 2010 at 11:37:10
Specs: Windows XP
I have email address data on row 1, but extends across columns a1 - gz1. How can I put in single column with each email address on a separate row?

i.e.. bill@coxnet.com; rick@verizon.net; lisack@vt.edu

to
bill@coxnet.com;
rick@verizon.net;
lisack@vt.edu

Thanks, Stevem


See More: tranfer data from many columns to rows

Report •

#1
September 16, 2010 at 12:23:32
Right Click the 1 in the Row numbers and choose Copy

Right Click A2 and choose Paste Special

Click Transpose

Click OK


Report •
Related Solutions


Ask Question