How to move Cells from Row to Colum
 

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

How to move Cells from Row to Colum
 

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" wrote:

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

How to move Cells from Row to Colum
 

Thank you for your anawer, that worked

"Elkar" wrote:

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" wrote:

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