AI Hub / AI posts
AI · 1 min read

PIVOTBY

PIVOTBY function in Excel: Groups and aggregates by row and column fields.

November 5, 2026
Excel functions / Lookup & Reference
Lookup & Reference function · Excel

PIVOTBY function

Groups and aggregates by row and column fields.

Availability

PlatformStatus
ExcelListed
Google SheetsNot listed
On Google Sheets: use QUERY. Use a query with group by and pivot.
Reference entry. Syntax, tested examples and a practice file arrive with the full guide. Open the official function list.