Functions
FLATTEN
Flattens an array into a single column
Try it
When to use it
When should I use FLATTEN?
Use FLATTEN to collapse a multi-dimensional array into a single column, useful before passing data to functions that expect a flat list.
Used in
Syntax
FLATTEN(array)Examples
=FLATTEN({1,2;3,4}) // => 1
=FLATTEN({1,2,3}) // => 1
=FLATTEN({42}) // => 42