Join

 

Description

The join() function takes two or more non-contiguous ranges and joins them into a single dataset.

Syntax

dataset join(rA, rB, ...)

Parameter

rA

a contiguous block of cells

rB

another contiguous block of cells

Return

Returns a single dataset, in general used for further calculations (math, statistical, etc.)

Examples

The following joins several ranges into a single dataset, then calculates a total value.

total(join(col(a)[1]:col(a)[32],col(b)[1]:col(b)[32])); // joins defined ranges and calculates total
=total(join(A1:A32,B1:B32)) //same as above, but use this syntax for cell or column formula only