How to move Cells from Row to Colum

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 05 Jun 2006 20:38 GMT

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

Reply to this Message

Elkar - 05 Jun 2006 20:56 GMT

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

> 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

Reply to this Message

John - 05 Jun 2006 21:21 GMT

Thank you for your anawer, that worked

> Select your row of data
> Copy
[quoted text clipped - 12 lines]
> > it is much more easier to read and change.
> > Thanks for any help

Reply to this Message