Convert Data in Columns to Rows

Glenn · Sep 20, 2004

Hello,

Is there a way to take a column of data and convert it
into rows?
For example: WAS: A1=1 A2=2 A3=3 NOW: A1=1 B1=2 C1=3

Thank you

Frank Kabel · Sep 20, 2004

Hi
use 'Edit - Paste Special - Transpose' for this

mzehr · Sep 20, 2004

Hi Glenn,
If you have a lot to do see also:
David McRitchie's website

http://www.mvps.org/dmcritchie/excel/snakecol.html