Convert data from column to row in Excel || Transpose function
Most of the time we need to convert our Excel Table from Column to Row in Excel due to a nice presentation. This task may take some time if you want to do it by manual process. With this tutorial, I will try my best to show you how you can do it in a simple way and easy way.
our target is like this -
To do it 1st you need to copy the required table-
2nd - After copy select the cell and right-click and select Paste Special option
3rd Step - From the Paste Special list options, you need to select Values and Transpose. Finaly need to click on OK.
After clicking on the OK the system will show the results as below-
Convert data from column to row in Excel || Transpose function
Reviewed by Mizanur Rahman
on
July 31, 2021
Rating:
Reviewed by Mizanur Rahman
on
July 31, 2021
Rating:
.jpg "Nuwave Brio Air Fryer Oven")
.jpg)
No comments: