Excel GROUPBY and PIVOTBY Functions
The GROUPBY and PIVOTBY functions are a significant breakthrough in Excel's toolbox of functions. They let you easily group or aggregate data, a concept that's been around in Excel since the days of PivotTables in 1993 and Power Query since 2010. But what's exciting about GROUPBY and PIVOTBY is that they simplify this process down …