| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I convert columns of data to rows in excel?
I am trying to convert 1 column of data into a row. Is there a simple way to
do this? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I convert columns of data to rows in excel?
Copy/Cut your row and rightclick the destination. Choose "Paste Special" and
check the "Transpose" option. That should do it! -- -SA "Glen in Pen" wrote: I am trying to convert 1 column of data into a row. Is there a simple way to do this? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I convert columns of data to rows in excel?
I just tried the Cut/Paste Special... and it's not available. You can only
do this using the Copy function. Weird... -- -SA "StumpedAgain" wrote: Copy/Cut your row and rightclick the destination. Choose "Paste Special" and check the "Transpose" option. That should do it! -- -SA "Glen in Pen" wrote: I am trying to convert 1 column of data into a row. Is there a simple way to do this? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I convert columns of data to rows in excel?
Sweet. Thanks!
"StumpedAgain" wrote: Copy/Cut your row and rightclick the destination. Choose "Paste Special" and check the "Transpose" option. That should do it! -- -SA "Glen in Pen" wrote: I am trying to convert 1 column of data into a row. Is there a simple way to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert data from multiple columns/rows into one column - help! | Excel Worksheet Functions | |||
| how can I convert data with fields in rows to fields as columns | Excel Discussion (Misc queries) | |||
| to convert columns to rows having mulit independent group columns | Excel Worksheet Functions | |||
| Instructions to convert columns to rows Excel help are not correct | Excel Worksheet Functions | |||
| Convert data from rows to columns | Excel Discussion (Misc queries) | |||
Linear Mode
