The TRANSPOSE function
Rows become columns, and vice versa, staying linked to the source: a change in one shows in the other.
Syntax
=TRANSPOSE(array)
In a French Excel: =TRANSPOSE(tableau).
Arguments
- array: the range to transpose.
An example
=TRANSPOSE(A1:L2)
Two rows of twelve months become twelve rows of two columns.
Pitfalls
- Before Excel 365, you must select the destination area and confirm with Ctrl+Shift+Enter.
- Occupied cells: #SPILL!.
Going further
- Unpivot or pivot: going from months in columns to one row per month, which is rarely a simple transposition.
Frequently asked questions
- TRANSPOSE or Paste Special Transpose?
- Paste Special copies frozen values; TRANSPOSE stays linked to the source.