This column introduces PIVOTBY, a new Excel function that may let you say bye-bye to PivotTables.

Excel's new Copilot function turns your prompts into formulas - how to try it It's so much easier to create, summarize, and analyze data now - no complex manual formulas required.