How to move Cells from Row to Colum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Thank you for your anawer, that worked

Elkar said:
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
Click to expand...
 
Back
Top