The Transpose feature in MS Excel is used to change a vertical range of cells to a horizontal range or vice versa.
Follow the steps below to learn how to use this feature:
- Copy a range of cells.
- Select a cell in the current or any other worksheet and right-click.
- From the shortcut menu that appears, select Paste Special.
- Check the Transpose check box.
Voila! Transposed! I know you will make use of this feature often!