SOLVED: VIDEO: Easily Swap Rows & Columns in Excel

In this short video we explain and demonstrate how to easily swap / switch / rotate / transpose rows and columns in Excel.  The process is to:

1. Select the rows and columns you want
2. Right click and select COPY
3. Right click on a cell in an open area of the worksheet (or a different worksheet) and select PASTE SPECIAL
4. Select the TRANSPOSE option

We also demonstrate that some of the instructions given, even by Microsoft, are incorrect.