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