View Single Post
  #2   Report Post  
swatsp0p
 
Posts: n/a
Default


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