ZIP

Merges the given arrays, element-wise, into a single array of rows.

Syntax

ZIP(ARRAY1, ARRAY2 [, ...]) 

Arguments

ARRAY

Type: array

A array of values of any type.

Returns

Type: array

The given arrays merged element-wise into a single array of rows.

The M-th element of the N-th argument will be the N-th field of the M-th output element. If the arguments have an uneven length, missing values are filled with NULL.