In this article, we will learn how to switch the row value into column value and column value into row value through Transpose formula in Excel.
Problem is: -Transposing the values in List1 (cells A2:A5) into a row, and the values in List2 (cells B10:F10) in to a column.
In Excel, we have Transpose formula to update the column data in row and row data in column. Also, we can use Index function along with Row function to convert the row data in column, and we will use a combination of Index function and column function to convert the column data in row.
Let’s take an example and understand how we can transpose the values:-
To transpose the values in Column A (List1) into a Row:
Follow below given steps:-
We can use Transpose function. Let’s see how we use the Transpose function.
How to transpose from a Row into a Column?
We have data in range A1:I1, and we want to update this data in range A2:A9.
We can use Transpose function as well. Now, let’s see how we can use the Transpose function.
This is the way we can update the row data into column and column data into row through formula in Excel.
Below you can find more example to learn about Transpose:-
If you liked our blogs, 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 at firstname.lastname@example.org
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.