Reference
No results for 'undefined'
    Powered by Algolia

    TRANSPOSE

    Transposes the rows and columns of a range of cells. If wrapInFrame TRUE, the result will be a Frame, otherwise - result will be inlined.

    Syntax

    =TRANSPOSE(range, [wrapInFrame])

    Parameters

    1. range
      • Type: Frame
      • Description: The range whose rows and columns will be swapped.
    2. wrapInFrame [optional]
      • Type: Boolean
      • Description: Wrap result in Frame, instead of inlining it

    Returns

    • Type: Frame
    • Description: The result of a transposition on a range of size m rows by n columns is therefore n rows by m columns.

    Example

    =TRANSPOSE(A1:B12)

    See Also

    Contents