Syntax
=TRANSPOSE(array)Arguments
| Argument | Required | Description |
|---|---|---|
array | Required | A range or array |
How to use TRANSPOSE
When TRANSPOSE returns more than one value, the result spills into the cells below and to the right. Keep those cells empty, or you get #SPILL!.
TRANSPOSE takes 1 required argument. Type =TRANSPOSE( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=TRANSPOSE({1,2,3})Result Spilled result
| A | |
|---|---|
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
=TRANSPOSE({1,2;3,4})Result Spilled result
| A | B | |
|---|---|---|
| 1 | 1 | 3 |
| 2 | 2 | 4 |
Related lookup and reference functions
- INDIRECTReturns the reference written in a text value, such as "B3" or "Sheet2!A1:A10".
- LOOKUPFinds a value in a sorted row or column and returns the value at the same position in another row or column.
- MATCHReturns the position of a value in a row or column.
- OFFSETReturns a reference shifted a number of rows and columns from a starting reference, optionally with a new size.
- ROWReturns the row number of a reference, or of the cell with the formula when left out.
- ROWSReturns the number of rows in a range or array.
- VLOOKUPLooks for a value in the first column of a table and returns the value in the same row from another column.
- XLOOKUPSearches a range or array for a match and returns the matching item from a second range or array.
- XMATCHReturns the position of an item in a row or column, with exact, approximate, wildcard and binary search options.