ZIP
Syntax
=ZIP(array1, array2, ...., arrayN)
Arguments
| Argument | Type | Description |
|---|---|---|
| array | Array | Array of items to combine |
Examples
=ZIP([1, 2, 3], ["a", "b", "c"])→[[1, "a"], [2, "b"], [3, "c"]]
=ZIP([1, 2, 3, 4], ["a", "b"])→[[1, "a"], [2, "b"]]
=ZIP([1, 2, 3, 4], ["a", "b"], ["Z", "Y", "Z"])→[[1, "a", "Z"], [2, "b", "Y"]]
Updated 2 months ago