top menu gradient

Extended example: using multiple keys

Copy the source data below and paste it to a new spreadsheet:

ABCD
1 weight height age name
21056foo
31053bar
415108baz
515104oaf
610126cool
Copy to clipboard

In A7 cell, group by "weight", then by "age"

=GROUP_BY(FRAME(A1:D6), "weight", "age")
Copy to clipboard

or (equivalent):

=GROUP_BY(FRAME(A1:D6), {"weight"; "age"})
Copy to clipboard

Open the result in nested frame view. Observe and open grouped data in "by_{name}" columns.

Nested: grouped by "weight" column
weight by_weight
110
Nested: data by "weight" = 10
age by_age
16
Nested: data by "age" = 6
weight height age name
11056foo
210126cool
23
Nested: data by "age" = 3
weight height age name
11053bar
215
Nested: data by "weight" = 15
age by_age
18
Nested: data by "age" = 8
weight height age name
115108baz
24
Nested: data by "age" = 4
weight height age name
115104oaf
Contents