Excel's GROUPBY and PIVOTBY functions can replace Pivot Tables in many everyday scenarios. Compared with Pivot Tables, these formulas update automatically when source data changes, expose their logic ...