MrExcel Publishing
Your One Stop for Excel Tips & Solutions

"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?

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"

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?