The TRANSPOSE function reverses the direction of the vertical and horizontal range of cells.
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.