In this short video we explain and demonstrate how to easily swap / switch / rotate / transpose rows and columns in Excel. The process is to:
- Select the rows and columns you want
- Right click and select COPY
- Right click on a cell in an open area of the worksheet (or a different worksheet) and select PASTE SPECIAL
- Select the TRANSPOSE option
We also demonstrate that some of the instructions given, even by Microsoft, are incorrect.