FLATARRAY / FLATTEN
Creates an array of all supplied values, flattening any arrays so that the array is a single array of values.
Syntax
=FLATARRAY(value1, value2, ...)
=FLATTEN(value1, value2, ...)
Arguments
| Argument | Type | Description |
|---|---|---|
| value | Any | The value for the specified item, values can be different types |
Examples
=FLATARRAY(123)→[123]
Creates a flattened array from the value 123
=FLATARRAY("A", 2, true)→["A", 2, true]
Creates a flattened array from the values "A", 2, and true
=FLATTEN(1, ARRAY(2, 3), 4)→[1, 2, 3, 4]
Creates a flattened array from the value 1, an array containing 2 and 3, and the value 4. Because the array values are flattened, the final array consists of all elements (without arrays): 1, 2, 3, 4.
=FLATTEN(1, ARRAY(2, ARRAY(3, 4)))→[1, 2, 3, 4]
Creates a flattened array from the value 1, an array containing 2 and and array containing the values 3 and 4. Because the array values are flattened, the final array consists of all elements (without arrays): 1, 2, 3, 4.
Updated 3 months ago