Excel functions / Dynamic arrays
TOROW function
Turns an array into a single row.
Syntax
=TOROW(array, [ignore], [scan_by_column])
Arguments
array: The array to flatten.ignore(optional): 0 keeps everything (default), 1 leaves out blanks, 2 errors, 3 both.scan_by_column(optional): TRUE reads down each column; FALSE (default) reads along each row.
When to use it
TOROW turns a range into a single row, reading row by row. With 1 as the second argument it skips empty cells.
Examples
A column as a row
A B C D E 1 Item Pen Stapler Folder 2 Pen 3 Stapler 4 Folder 5 Tape 6 Glue 7 Ruler In C1:
=TOROW(A2:A4)→ Pen, Stapler, Folder
Common mistakes
- No room to spill. The row needs empty cells to its right, or the result is #SPILL!.
TOROW in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Danish: TILRÆKKE
- Finnish: RIVIIN
- French: DANSLIGNE
- German: ZUZEILE
- Polish: DO.WIERSZA
- Portuguese (Portugal): PARALIN
- Russian: ПОСТРОК
- Swedish: TILLRAD
- Turkish: SATIRA