S
Shaun
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?
be in a row now. What's the best way of doing this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
H
Hayeso
Edit Copy
EDit...Paste Special...Transpose
EDit...Paste Special...Transpose
M
mzehr
Hi,
Will work to a point. Remember that there are only 255 columns in Excel.
Will work to a point. Remember that there are only 255 columns in Excel.
M
mzehr
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
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
M
mzehr
I mean 256 Columns not 255
mzehr said:Hi,
Will work to a point. Remember that there are only 255 columns in Excel.
G
Gord Dibben
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
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