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

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

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