ZIPALL
Syntax
=ZIPALL(array1, default1, array2, default2, ...., arrayN, defaultN)
Arguments
| Argument | Type | Description |
|---|---|---|
| array | Array | Array of items to combine |
| default | Any | Default value to use for any missing items |
Examples
=ZIPALL([1, 2, 3], ["a", "b", "c"])→[[1, "a"], [2, "b"], [3, "c"]]
=ZIPALL([1, 2, 3, 4], 0, ["a", "b"], "z")→[[1, "a"], [2, "b"], [3, "z"], [4, "z"]]
Updated 2 months ago