How to Use TRANSPOSE Function

The TRANSPOSE function reverses the direction of the vertical and horizontal range of cells.


= TRANSPOSE(array)


Array is required, the data range to be transposed.

Step 1: Count the number of rows and columns of the array, and select a new range with reversed row and column number. For example, there are 6 rows and 2 columns. You need to select a data range with 2 rows and 6 columns.

Step 2: Type in the formula =TRANSPOSE(A1:B6);

Step 3: Press "Ctrl + Shift +Enter" together.

Download: TRANSPOSE Function

Leave a Reply