Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I convert a column into a row?
Excel Question. I simply want to convert a column of figures [each in
different cells] into a row with a similar number of cells. Must be simple, but can't seem to find how to do it. Thanks for any replies, guys!! |
#2
|
|||
|
|||
Select the cells in the column you want to paste in the row. copy (control
C). Select the same number of cells in a row, click Edit Paste Special. Select transpose. Click ok. - Mangesh "Lenworth" wrote in message ... Excel Question. I simply want to convert a column of figures [each in different cells] into a row with a similar number of cells. Must be simple, but can't seem to find how to do it. Thanks for any replies, guys!! |
#3
|
|||
|
|||
And note that there only 256 columns in a sheet so you cannot transpose more
than that to a row. Gord Dibben Excel MVP On Fri, 20 May 2005 14:54:01 +0530, "Mangesh" wrote: Select the cells in the column you want to paste in the row. copy (control C). Select the same number of cells in a row, click Edit Paste Special. Select transpose. Click ok. - Mangesh "Lenworth" wrote in message ... Excel Question. I simply want to convert a column of figures [each in different cells] into a row with a similar number of cells. Must be simple, but can't seem to find how to do it. Thanks for any replies, guys!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort by row instead of by column? | Excel Worksheet Functions | |||
how do I convert a date and time column to a time column | Excel Worksheet Functions | |||
how do I easily convert a single column of text (multiple rows si. | Excel Discussion (Misc queries) | |||
Copying the contents of a column into a chart | Excel Worksheet Functions | |||
how to convert multiple columns of data into one single column? | Excel Worksheet Functions |