Skip to content
Excel

TRANSPOSE function in Excel

Returns the transpose of an array

=TRANSPOSE(array)

TRANSPOSE syntax and parameters

One argument, one required.

  • arrayarrayRequired

    An array or range of cells on a worksheet that you want to transpose. The transpose of an array is created by using the first row of the array as the first column of the new array, the second row of the array as the second column of the new array, and so on. If you're not sure of how to enter an array formula, see Create an array formula.

TRANSPOSE examples

Formulas you'll actually reuse.

  1. Twelve month names down a column, laid across as headers:

    =TRANSPOSE(A2:A13)

  2. Weight a row of scores by a column of weights — TRANSPOSE lines them up:

    =SUMPRODUCT(B2:D2, TRANSPOSE(F2:F4))

    Result84.5

TRANSPOSE in Google Sheets

Same name — your formula ports as-is.

Try TRANSPOSE in the playground

Edit the example — nothing to install.

Preloaded with the TRANSPOSE formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.