Transposing in Excel

Have you ever needed to reformat data so that the columns were the rows and the rows were the columns?

Transposing in Excel is straightforward and easy.

  • Select your data
  • Copy your data with Control + C
  • Click on the cell in which you want to transpose the data
  • Right Click and choose Paste Special
  • Check the Transpose box and click OK