TRANSPOSE

Excel Functions

Flip the orientation of a range of cells

Syntax

EXCEL

=TRANSPOSE(array)

Arguments

Parameter	Description
`array`	The array or range of cells to transpose.

Return Value

An array in a new orientation.

Details

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. In other words, TRANSPOSE "flips" the orientation of a given range or array: When a range or array is transposed, the first row becomes the first column of the new array, the second row becomes the second column of the new array, the third row becomes the third column of the new array, and so on. TRANSPOSE can be used with both ranges and arrays. Transposed ranges are dynamic. If data in the source range changes, TRANSPOSE will immediately update data in the target range. When given a vertical array, TRANSPOSE returns a horizontal array: To transpose the vertical range A1:A5 into a horizontal array:

Examples

When given a vertical array, TRANSPOSE returns a horizontal array:

EXCEL

=TRANSPOSE({"a";"b";"c"}) // returns {"a","b","c"}

Examples

To transpose the vertical range A1:A5 into a horizontal array:

EXCEL

=TRANSPOSE(A1:A5) // vertical to horizontal

Examples

To transpose the horizontal range A1:E1 to a vertical array:

EXCEL

=TRANSPOSE(A1:E1) // vertical to horizontal

Examples

In the example shown above, the formulas in I5 and F12 are:

EXCEL

=TRANSPOSE(B5:F6) // formula in I5
=TRANSPOSE(B12:C16) // formula in F12

TRANSPOSE with other functions

TRANSPOSE can "catch" and transpose the output from another function. The formula below changes the result from XLOOKUP from a horizontal orientation

EXCEL

=TRANSPOSE((XLOOKUP(value,lookup_range,return_range))