GROUPBY app icon

Google Sheets add-on

GROUPBY / PIVOTBY for Google Sheets

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
Read function docsMarketplace listing URL pending publication
Sales by region=GROUPBY(A1:A6, C1:C6, "SUM", TRUE, TRUE)East 215; West 75; Total 290
Pivot by quarter=PIVOTBY(A1:A6, B1:B6, C1:C6, "SUM", TRUE)Q1/Q2 columns
Rep rollup=GROUPBY(A1:A6, B1:B6, "TEXTJOIN: | ", TRUE)Ava | Cy | Ava

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.

Function map

Summary formulas plus GB_ aliases

Open full reference

Summary Tables

GROUPBYPIVOTBY

Namespaced Aliases

GB_GROUPBYGB_PIVOTBY

Aggregation coverage

Use numeric summaries such as SUM, COUNT, AVERAGE, MIN, MAX, and MEDIAN, or text rollups such as TEXTJOIN, UNIQUE, FIRST, and LAST.

Formula output

Results spill into regular cells, so they can be referenced, charted, copied, and composed with other Sheets formulas.

    xs