Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
TOROW
TOROW flattens a range or array into a single row, reading values left-to-right and top-to-bottom by default. You can optionally ignore blank cells or errors, and change the scan order. It is an Excel 365 and Google Sheets dynamic function, useful for consolidating scattered values into a single row for further processing.
Excel
=TOROW(A2:B3)Google Sheets
=TOROW(A2:B3)Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1A2:B3 is the source range — it contains 2 rows and 2 columns, so 4 values total.
- 2TOROW reads the values row by row (left-to-right, top-to-bottom) by default.
- 3The result is a single horizontal row of 4 cells: A2, B2, A3, B3.