Spread WPF 17
Spread WPF Documentation / Formula Reference / Formula Functions / TRANSPOSE
In This Topic
    TRANSPOSE
    In This Topic

    Summary

    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)

    See Also