How To Use TOCOL()


This function transforms an array or range of cells into a single column. TOCOL 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 TOCOL reads values from the source array.

How To Actually Use TOCOL() in Sheets

TOCOL(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 TOCOL() formula: