GROUPBY: Excel's Answer to Pandas groupby - Without a Pivot Table in Sight
A pivot table is a tool you operate. GROUPBY is the same group-and-aggregate logic as a single spilled formula - the summary recalculates itself, with no fields to drag and nothing to refresh.
