Better Sheets

Learn ↓

Free Resources ↓

Member LoginStart 7 Day Free Trial

How To Use TOROW()

Description

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.

How To Actually Use TOROW() in Sheets

TOROW(array_or_range, [ignore], [scan_by_column])
Google Docs Help

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 Trial

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons