Microsoft Excel has introduced the PIVOTBY function in Microsoft 365, enabling users to create Pivot Table-like summaries directly with formulas. The function automates updates, allows advanced ...