How do I quickly transfer data from a column into a row?

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

Guest

I have about 500 3 digit numbers in a single column in Excel. I want them to
be in a row now. What's the best way of doing this?
 
Hi,
Will work to a point. Remember that there are only 255 columns in Excel.
 
Hi Shaun
Using the paste special transpose method will only work to a point. There
are 256 columns in Excel which will limit you. Another workaround might be
to put your data in multiple rows. You can use the paste special method
twice, or you can snake the column. For mor info see:
http://www.mvps.org/dmcritchie/excel/snakecol.htm
 
Shaun

Excel has 256 columns limit.

You cannot Transpose a 500 cell column into one row.

Perhaps split into 250 and 250 and Transpose to two rows?

Gord Dibben Excel MVP
 
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

Excel Help to copy information from one row at a time to another sheet 1
transfer a column into a row? 2
Move data from every other row to columns 0
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
Copy paste data from a column to a row 0
How to filter rows data based on background color of individual cells 1
Conditional SUBTOTAL in XL210 Table 7
how do I excel 0

Back
Top