Can I rotate data in Excel table (rows to columns, and vv)? in Excel General Questions    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              Marcus Ricci 1/19/2006 6:27 AM PST   Question   Is there a way - without using PivotTable - to rotate data in an Excel table: rows become columns and columns become rows? I wouldn't mind cutting and pasting, or macros, or anything else.     Was this post helpful to you?         Reply |   Top           LPS 1/19/2006 6:37 AM PST   Answer   You can try using the Edit | Paste Sepcial |Transpose feature: 1. Select and copy the data you want to transpose 2. Position the cell pointer in the first destination cell 3. Select Edit | Paste Special | Transpose What was a column should now be a row and vice versa. Cheers, -- LPS "Marcus Ricci" wrote: > Is there a way - without using PivotTable - to rotate data in an Excel table: > rows become columns and columns become rows? I wouldn't mind cutting and > pasting, or macros, or anything else.     Was this post helpful to you?         Reply |   Top           Luis 7/14/2008 8:10 AM PST   Is there a way to rotate info from a range for example: 10 134 - 1205 2.72 CELL1 FALSE FALSE 10 134 - 1402 0.12 CELL1 FALSE FALSE into a single row where the info from above will display as follow 10 134 - 1205 2.72 CELL1 FALSE FALSE 10 134 - 1402 0.12 CELL1 FALSE FALSE "LPS" wrote: > You can try using the Edit | Paste Sepcial |Transpose feature: > > 1. Select and copy the data you want to transpose > 2. Position the cell pointer in the first destination cell > 3. Select Edit | Paste Special | Transpose > > What was a column should now be a row and vice versa. > > Cheers, > -- > LPS > > > "Marcus Ricci" wrote: > > > Is there a way - without using PivotTable - to rotate data in an Excel table: > > rows become columns and columns become rows? I wouldn't mind cutting and > > pasting, or macros, or anything else.     Was this post helpful to you?         Reply |   Top           Dave Peterson 1/19/2006 6:47 AM PST   Answer   Depending on the number of rows you're using--since there's only 256 columns to work with. Select your range to Transpose. find a nice open spot that doesn't touch that original range (a new sheet???) Edit|paste special|check the Transpose box and hit ok. Marcus Ricci wrote: > > Is there a way - without using PivotTable - to rotate data in an Excel table: > rows become columns and columns become rows? I wouldn't mind cutting and > pasting, or macros, or anything else. -- Dave Peterson     Was this post helpful to you?         Reply |   Top           Dave Peterson 1/19/2006 7:20 AM PST   Answer   There's also a worksheet function you could use: =transpose() Say you want to transpose A1:B5, you could select C1:G2 and type: =transpose(a1:b5) but hit shift-ctrl-enter to do the work. Dave Peterson wrote: > > Depending on the number of rows you're using--since there's only 256 columns to > work with. > > Select your range to Transpose. > find a nice open spot that doesn't touch that original range (a new sheet???) > Edit|paste special|check the Transpose box and hit ok. > > Marcus Ricci wrote: > > > > Is there a way - without using PivotTable - to rotate data in an Excel table: > > rows become columns and columns become rows? I wouldn't mind cutting and > > pasting, or macros, or anything else. > > -- > > Dave Peterson -- Dave Peterson     Was this post helpful to you?         Reply |   Top           Marcus Ricci 1/19/2006 3:53 PM PST   you guys are PHENOMENAL! i remember the "paste special" transpose function now, but had forgotten it. i didn't know about the worksheet transpose function, though. it's a shame that it doesn't show in the help section under "rotate data" or "rotate table", but only under "transpose." it really IS all about language, even in numbers. marcus "Dave Peterson" wrote: > There's also a worksheet function you could use: > > =transpose() > > Say you want to transpose A1:B5, you could select C1:G2 and type: > =transpose(a1:b5) > but hit shift-ctrl-enter to do the work. > > > > Dave Peterson wrote: > > > > Depending on the number of rows you're using--since there's only 256 columns to > > work with. > > > > Select your range to Transpose. > > find a nice open spot that doesn't touch that original range (a new sheet???) > > Edit|paste special|check the Transpose box and hit ok. > > > > Marcus Ricci wrote: > > > > > > Is there a way - without using PivotTable - to rotate data in an Excel table: > > > rows become columns and columns become rows? I wouldn't mind cutting and > > > pasting, or macros, or anything else. > > > > -- > > > > Dave Peterson > > -- > > Dave Peterson >     Was this post helpful to you?         Reply |   Top           Pete 1/19/2006 6:47 AM PST   Answer   Highlight the area covered by your table, then <copy>, then move the cursor away from your table where you want the new table to be, then Edit | Paste Special | Transpose (near the bottom) then OK <esc>. Your could then delete your first table if you wish. Hope this helps. Pete     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies