The TRANSPOSE function switch or rotate cells from vertical to horizontal and vice versa.Â
-
Select the top-left cell of the target output range.Â
-
Enter =TRANSPOSE(array), where array is the original range of cells that you want to transpose. For example: =TRANSPOSE(A1:C25).Â
See more about the TRANSPOSE function.
The TRANSPOSE function switch or rotate cells from vertical to horizontal and vice versa.Â
-
Select the top-left cell of the target output range.Â
-
Enter =TRANSPOSE(array), where array is the original range of cells that you want to transpose. For example: =TRANSPOSE(A1:C25).Â
See more about the TRANSPOSE function.
The TRANSPOSE function switch or rotate cells from vertical to horizontal and vice versa.Â
-
Select the top-left cell of the target output range.Â
-
Enter =TRANSPOSE(array), where array is the original range of cells that you want to transpose. For example: =TRANSPOSE(A1:C25).Â
See more about the TRANSPOSE function.