The Excel TRANSPOSE function "flips" the orientation of a given range or array. TRANSPOSE converts a vertical range to a horizontal range, or a horizontal range to a vertical range. You must enter the TRANSPOSE function as an array formula.

Flip the orientation of a range of cells

An array in a new orientation.

=TRANSPOSE (array)

**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.