GROUPBY and PIVOTBY vs Pivot Table Excel’s GROUPBY and PIVOTBY functions provide a modern, formula‑based alternative to PivotTables using dynamic arrays. The key distinction is