Microsoft Excel’s PIVOTBY function, now available in Microsoft 365, streamlines the creation of dynamic data summaries without the manual refreshes and rigid layouts of traditional PivotTables.