Syntax
TRANSPOSE(array)
| Parameter | Description |
|---|---|
| array | Parameter of the TRANSPOSE function. |
Examples
Flip a row to a column
Formula
=TRANSPOSE(A1:F1)
Converts 6 values in a single row into a 6-row column. Useful for turning horizontal headers into a vertical list.
Transpose a data table
Formula
=TRANSPOSE(A1:C5)
Converts a 5-row by 3-column table into a 3-row by 5-column table. Row 1 becomes column 1, etc.
Create a column vector for MMULT
Formula
=MMULT(A1:C1, TRANSPOSE(D1:F1))
Transposes the second row vector into a column vector for matrix multiplication — returns the dot product of the two vectors.
Common Errors
#VALUE!
In older versions, TRANSPOSE entered without Ctrl+Shift+Enter in a legacy array formula context produces this error.
#SPILL!
The output area is not empty and the transposed result cannot spill.
Tips
Dynamic with spill
In modern spreadsheets, TRANSPOSE automatically resizes when the source data changes. No need for Ctrl+Shift+Enter anymore.
Combine with other array functions
TRANSPOSE works well inside SORT, FILTER, and MMULT where you need to change data orientation before processing.
Paste Special as alternative
For a one-time flip, Copy > Paste Special > Transpose is faster. Use the TRANSPOSE formula when you want a live link that updates as source data changes.
Try TRANSPOSE in Viztab
Import your data and use TRANSPOSE with 370+ other formulas. No signup required.
Open Viztab