You can try this:
Insert a blank sheet.
On sheet3, press CTRL+A twice to highlight the entire sheet and press
CTRL+C (to copy the sheet)
go to your new blank sheet and with cell A1 selected, right click and
choose Paste Special... check the Transpose box and click OK
Your sheet should now appear rows to columns and columns to rows.
Does this work for you?
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=470216