Flipping a table

February 2002 View as JSON

A quick tip explaining how to transpose rows and columns in an Excel spreadsheet using Paste Special.

Q: How do I flip an Excel table so that the information in rows goes in columns and columns rows?

A: Select the cells you want to flip and hit copy. Open a new workbook or sheet. Then go to PASTE SPECIAL and down near the bottom click on transpose. Then hit OK.