This function transforms an array or range of cells into a single row. TOROW can scan values:
- By column, top to bottom
- By row, left to right
The scan_by_column
argument is a boolean value that controls how TOROW reads values from the source array.
Sample Usage
TOROW(A1:C3)
: A TOROW
function that keeps all values and scans by row.
TOROW(A1:C3, 1, TRUE)
: A TOROW
function that ignores blanks and scans by column.
Syntax
TOROW(array_or_range, [ignore], [scan_by_column])
array_or_range
: The array or range of cells to return as a row.[ignore]
: By default, no values are ignored. Specify one of these values:- 0: Keep all values
- 1: Ignore blanks
- 2: Ignore errors
- 3: Ignore blanks and errors
[scan_by_column]
: The boolean value ofscan_by_column
determines how the array is scanned. By default, theTOROW
function scans the array by row.- True: scans the array by column
- False: scans the array by row
Examples
Use simple data transformation operation with TOROW
Example data:
A | B | C | |
---|---|---|---|
1 | Ben | Peter | Mary |
2 | John | Hillary | Jenny |
3 | Agnes | Harry | Felicity |
Example: Input this formula in E1: =TOROW(A1:C3)
Result:
E | F | G | H | I | J | K | L | M | |
---|---|---|---|---|---|---|---|---|---|
1 | Ben | Peter | Mary | John | Hillary | Jenny | Agnes | Harry | Felicity |
Ignore blanks with TOROW
Example data:
A | B | C | |
---|---|---|---|
1 | Ben | Peter | Mary |
2 | John | Jenny | |
3 | Agnes | Harry | Felicity |
Example: Input this formula in E1: =TOROW(A1:C3, 1)
Result:
E | F | G | H | I | J | K | L | |
---|---|---|---|---|---|---|---|---|
1 | Ben | Peter | Mary | John | Jenny | Agnes | Harry | Felicity |
Scan by column with TOROW
Example data:
A | B | C | |
---|---|---|---|
1 | Ben | Peter | Mary |
2 | John | Hillary | Jenny |
3 | Agnes | Harry | Felicity |
Example: Input this formula in E1: =TOROW(A1:C3, 0, TRUE)
Result:
E | F | G | H | I | J | K | L | M | |
---|---|---|---|---|---|---|---|---|---|
1 | Ben | John | Agnes | Peter | Hillary | Harry | Mary | Jenny | Felicity |
Related functions
- TOCOL: This function transforms an array or range of cells into a single column.