ƒxPlainFormulaThink in English. Formula in Excel.

FUNCTION CATALOGUE / LOOKUP & REFERENCE

TRANSPOSE Excel function

Switches rows and columns.

Correct sentence to use

Transpose [range], swapping rows and columns.

Modify this query in PlainFormula →

Example formula

=TRANSPOSE(A1:C4)

Transposes array dimensions.

Syntax

TRANSPOSE(array)

Argument signature: array

Availability note

Commonly available in current Excel; verify platform and locale-specific behaviour.

Check Microsoft's Excel function documentation ↗

← Browse all functions