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.
Description
How To Actually Use TOROW() in Sheets
TOROW(array_or_range, [ignore], [scan_by_column])
0Better Sheets Tutorials
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Find more formulas here at Better Sheets.
Learn more about the TOROW() formula:
Better Sheets
Something for everyone to Learn Google Sheets. Includes Google Sheets for Beginners and Advanced Google Sheets Tutorials alike.
Start 7 Day Free TrialGoogle Sheets Help
Google Sheets Courses
Google Sheet Templates and Tools
Google Sheet Add Ons