TRANSPOSE function
The TRANSPOSE function is one of the lookup and reference functions. It is used to convert columns into rows and rows into columns.
Syntax
TRANSPOSE(array)
The TRANSPOSE function has the following arguments:
| Argument | Description |
|---|---|
| array | A reference to a range of cells. |
Notes
Please note that this is an array formula. To learn more, please read the Insert array formulas article.
How to apply the TRANSPOSE function.
Examples
The figure below displays the result returned by the TRANSPOSE function.
