1. Open the spreadsheet and select the area to be transposed (flipped)
  2. Select Edit, Copy from the menu bar
  3. Select a single cell in the spreadsheet (or in a new spreadsheet) where you want to paste the data. This cell will be the upper left-hand corner of your new data.
  4. Select Edit, Paste Special from the menu bar
  5. Mark the Transpose option
  6. Click OK