Excel Tips - Paste Special to Transpose
- Create and Learn
- Nov 8, 2020
- 1 min read
Updated: Nov 10, 2020

You've got a bunch of rows, and you want them to be columns.
Or vice versa...
1- Copy that data, select Paste Special, check the Transpose box, and click OK to paste into a different orientation.
2- Columns become rows, rows become columns!
Comments