Transpose is the function that we can use to convert the horizontal range into vertical range and vertical range into horizontal range in Microsoft Excel.
In Microsoft Excel we have 2 ways of Transpose the data.
Let’s take an example and understand how we can use transpose function?
We have name list in a column and we want to update it in row. How do we do it through Transpose function?
Follow below steps:-
In this way, we use Transpose function in Microsoft Excel.
How to use Transpose Option to convert the data from Vertical to horizontal and vice versa?
You will find this option under the Paste Special option. Now we will see how we can use this option to convert the range’s position.
Follow below steps:-
This is called Transpose and these are the ways to use the Transpose function and Option in Microsoft Excel.
Below you can find more example to learn about Transpose:-
How to transpose cells in Microsoft Excel
How to transposing Values from Columns into Rows, and Vice Versa
How to Copy Vertical and Paste Horizontal in Microsoft Excel
If you liked our blog, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook. We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us @ info@exceltip.com
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.