Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Between Orientation of Rows and Columns
Is there a way to take a Row of data and turn it into a Column instead ?
My usual way of doing this is to re-type it again. But I'm starting to get tired of that way (go and figure). |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Between Orientation of Rows and Columns
Either use the TRANSPOSE function, or copy and then Edit/ Paste Special/
Transpose. -- David Biddulph Jim D. wrote: Is there a way to take a Row of data and turn it into a Column instead ? My usual way of doing this is to re-type it again. But I'm starting to get tired of that way (go and figure). |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Between Orientation of Rows and Columns
Hi Jim,
Try Edit Paste Special Transpose OK. Copy the column, then select the row you want then do the Paste/Transpose. HTH Regards, Howard "Jim D." wrote in message ... Is there a way to take a Row of data and turn it into a Column instead ? My usual way of doing this is to re-type it again. But I'm starting to get tired of that way (go and figure). |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Between Orientation of Rows and Columns
Hello,
if you select the data, right click and copy. Go to where you want the column information and right click, Paste Special and tick the Transpose option at the bottom. This also changes column info into row info if you ever need to do that. -- Kevin Smith :o) "Jim D." wrote: Is there a way to take a Row of data and turn it into a Column instead ? My usual way of doing this is to re-type it again. But I'm starting to get tired of that way (go and figure). |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Between Orientation of Rows and Columns
Copy the rowSelect a cellPasteSpecialSelect TransposeOK
-- If this post helps click Yes --------------- Jacob Skaria "Jim D." wrote: Is there a way to take a Row of data and turn it into a Column instead ? My usual way of doing this is to re-type it again. But I'm starting to get tired of that way (go and figure). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing data orientation from one sheet to another | New Users to Excel | |||
Changing data orientation from one sheet to another | New Users to Excel | |||
Changing orientation of pages | Excel Worksheet Functions | |||
Changing fill orientation | Excel Discussion (Misc queries) | |||
Changing chart orientation | Charts and Charting in Excel |