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 versaPosted 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 versaPosted by Dwight on August 08, 2001 9:00 AM
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.