RANGE

Creates a nested JSON array from specified cell range. Basically this is the same as using array with nested and flat parameter set to true.

Syntax

=RANGE(Cellrange)

Arguments

Name	Description
Cellrange	Source Range to retrieve data from.

Return

A nested list of cell values.

Examples

Formula	Result	Comment
=RANGE(A1:A1)	[[42]]	Range defines only one cell, so returned list contains one list with one value.
=RANGE(A1:C1)	[[42, 23, 13]]	Range defines 3 values over 1 row, so returned list contains a list with 3 values.
=RANGE(A1:B2)	[[42, 23], [13, 17]]	Range defines 4 values over 2 rows, so returned list contains 2 lists with 2 values each.