Lesson#10: Rotate table data from rows to column and vice versa by TRANSPOSE
![Lesson#10: Rotate table data from rows to column and vice versa by TRANSPOSE](https://excelabcd.co.in/wp-content/uploads/2017/11/excelabcd-lesson-10-1.png)
You are having a table full of data and you want to convert columns to rows or vice versa. Excel has a feature that is TRANSPOSE which allows pasting rows as columns and columns as rows. For Example, I have shown a table below the image.
![](https://excelabcd.co.in/wp-content/uploads/2017/11/lesson10-1-1.png)
I want to copy the selected portion and convert it into a paste as rotated (From columns to rows and vice versa). I will have to copy and paste it as TRANSPOSE like in the below picture.
![](https://excelabcd.co.in/wp-content/uploads/2017/11/lesson10-3-1.jpg)
This will make your table rotate like this.
![](https://excelabcd.co.in/wp-content/uploads/2017/11/lesson10-2.png)
If your data contains formulas then excel automatically updates them to match the new placement.
Related Video Tutorials:
Thank You. Stay connected with Excelabcd.
Ne’er knew this, regards for letting me know.
Hey keep following