Spread Formula Reference
TRANSPOSE
Formula Functions > Functions T to Z > TRANSPOSE

This function returns a vertical range of cells as a horizontal range or a horizontal range of cells as a vertical range.

Syntax

TRANSPOSE(array)

Arguments

The array argument is a range of cells or an array that you want to switch.

Remarks

This function uses the first row of the array as the first column of the new array and so on.

Use the INDEX function to get individual elements from the returned array.

Data Types

Accepts an array. Returns an array.

Examples

TRANSPOSE(A2:A5)

Version Available

This function is available in product version 2.0 or later.

See Also

HLOOKUP | INDEX | LOOKUP | VLOOKUP | Lookup Functions