Column to rows

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

Guest

Folks:


I have a bunch of information in a single column of a spread sheet.
I would like to "INVERT" this infomation so that this column becomes a
row.and all information is preserved.

* Is there a way to accomplish this goal - within Excel 2003 - without
loss of any information?



Thanks,
Jo.
 
What version of Excel?

2003 down to 97 have only 256 columns so the the amount of data you can
transpose from one column to one row is 256 cells.

2007 has 16384 columns.

Insert a new row above your column of data.

Select the data and copy.

Select A1

Edit>Paste Special>Transpose>OK>Esc


Gord Dibben MS Excel MVP
 
Your subject says "column to rows"

In the body you state "this column becomes a row"

Perhaps you meant one column to multiple rows?

Post back with more detail if that's the case.


Gord
 
You must log in or register to reply here.

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

Printing SQL query results in a list of columns, instead of one long column 1
Converting Letters To Numbers Summary??? 2
Mailing address block: sorting 1 row to columns 1
Extracting data from Multiple columns to a Single row 1
Single column to multiple columns 5
moving rows to another sheet 3
Show Only Fields Needed 0
Exchange row and columns 3

Back
Top