Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Changing Columns to Rows
Is there a way to change a spreadsheet so that the columns become rows and the rows become columns... Other than retyping the whole thing? Thanks! -- jenbrunson ------------------------------------------------------------------------ jenbrunson's Profile: http://www.excelforum.com/member.php...o&userid=23777 View this thread: http://www.excelforum.com/showthread...hreadid=467509 |
#2
|
|||
|
|||
jenbrunson Wrote: Is there a way to change a spreadsheet so that the columns become rows and the rows become columns... Other than retyping the whole thing? Thanks! Hi jenbrunson Select the data Edit Copy select a blank cell Edit Paste Special check the transpose box click OK Works for Columns to Rows and Rows to Columns -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=467509 |
#3
|
|||
|
|||
That's it! Wonderful, thanks so much Paul! -- jenbrunson ------------------------------------------------------------------------ jenbrunson's Profile: http://www.excelforum.com/member.php...o&userid=23777 View this thread: http://www.excelforum.com/showthread...hreadid=467509 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dealing with data in several columns AND rows | Excel Discussion (Misc queries) | |||
How to reverse order of rows and columns | Excel Discussion (Misc queries) | |||
Changing Columns to Rows Question | Excel Discussion (Misc queries) | |||
hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) |