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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro for row showing no column markings 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel Move or Copy Stopped Working? 0
Moving data from column to row in groups of 250 per row for fourrows, then skip a row and continue t 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel worksheet moved all data from multipl cells into one 1

Back
Top