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