How to move Cells from Row to Colum

[John]

I have imported data from a csv file into Excel (2003). When it appears in
Excel all of the data are in cells accross the sheet. (All in Row 1).
How can I move these cells so that they show up in one colum (Up and Down),
it is much more easier to read and change.
Thanks for any help

 

[Elkar]

Select your row of data
Copy
Select a cell below your data in the column you want to move to
Paste Special
Check the "Transpose" box
Click OK
You can then delete Row 1

HTH,
Elkar

 

[John]

Thank you for your anawer, that worked

Select your row of data
Copy
Select a cell below your data in the column you want to move to
Paste Special
Check the "Transpose" box
Click OK
You can then delete Row 1

HTH,
Elkar