GROUPBY reference
GROUPBY / PIVOTBY
Build dynamic summary and pivot tables with formula-first GROUPBY, PIVOTBY, and namespaced GB_ aliases.
Dynamic summary tables
Pivot-style columns
Text aggregation
No external API calls
Formula-first reporting
Turn raw rows into reusable summaries without rebuilding QUERY, UNIQUE, and SUMIF formulas.
Pivot replacements
Create quarter, status, owner, or segment columns that spill from one formula and update with the data.
Text rollups
Collect names, notes, tags, and unique values by group with TEXTJOIN and UNIQUE aggregations.