TOCOL function

Returns the array in a single column

=TOCOL(array, [ignore], [scan_by_column])

Example
Returns the array (A1:D5) in a single column

  • Type “TOCOL(=”
  • Click “fx” in the formula bar.
  • In “array”, select from cell “A1” to cell “D5”
  • In “ignore”, Type “1” to ignore blanks.
  • Click on “OK”