- array – The array or range of cells to transpose.
The TRANSPOSE function converts a vertical range of cells to a horizontal range of cells, or a horizontal range of cells to a vertical range of cells. Use it to “flip” a range of cells from one orientation to another.
When array is transposed, the first row of array is used as the first column of the new array, the second row of array is used as the second column of the new array, the third row of array is used as the third column of the new array, and so on.
You must enter the TRANSPOSE function as an array formula that contains same number of cells as array, using Control + Shift + Enter.
The new array must occupy the same number of rows as the source array has columns, and the same number of columns as the source array has rows.
For a one-off conversion, you can use paste special > transpose.