Spread Formula Reference
Formula Functions / Functions T to Z / TRANSPOSE
In This Topic
    TRANSPOSE
    In This Topic

    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