How to Transpose Spreadsheets (i.e. swap rows and columns)

If you want to switch your spreadsheet columns to rows, and rows to columns, there is an easy way.

     1. Create a new sheet in your workbook. Name it “Destination”
     2. In the original sheet, highlight the a Highlight the section you would like to transpose
     3. Mouse over any of the selected area, right click, and select Copy
     4. Click in cell A1 of the Destination sheet
     5. Right click in cell A1, select paste special -> Transpose

The “Destination” sheet will show the transposed version

Leave a Reply

Your email address will not be published. Required fields are marked *