Archive of Mr Excel Message Board


Back to General Excel archive index
Back to archive home

"flip" the table--convert rows to columns and vice versa

Posted by Rebecca on August 08, 2001 8:49 AM
Is there any easy way to "flip" or "tilt" a table so that the row values
become columns and the columns rows?


Re: "flip" the table--convert rows to columns and vice versa

Posted by Dwight on August 08, 2001 9:00 AM
select table
Choose "Edit, Copy"
Select cell to serve as upper left corner of revised table.
Choose "Edit, Paste Special, All & Transpose"

Re:

Posted by John on August 24, 2001 6:01 AM


That's great when the table contains data. How do I do the same when it also contains relative reference formulae and keep the links intact?


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.