Functions
TOCOL
Converts an array to a single column
Try it
When to use it
When should I use TOCOL?
Use TOCOL to reshape a 2-D array or multi-row range into a single column — useful when you need to feed a flat list of values into UNIQUE, SORT, or other single-column functions.
Used in
Syntax
TOCOL(array, [ignore], [scan_by_col])Examples
=TOCOL({1,2;3,4}) // => 1
=TOCOL({1,2,3}) // => 1
=TOCOL({1,2,3;4,5,6;7,8,9}) // => 1