Flattens the values from one or more provided ranges of cells into a vertical stack of values in a single column.
Sample Usage
FLATTEN(A1:C10, D1:E10)
Syntax
FLATTEN(value1, [value2, value3, ...])
- value1 - The first value, or range of cell values, to place in the column.
- value2 - [OPTIONAL] The second value, or range of cell values, to place in the column.
Examples
FLATTEN(A1:C10, D1:E10) copies all of the values in the ranges A1:C10 and D1:E10 into a vertical stack of values in a single column.