How to Use the PIVOTBY Function in Excel
Reorganize your data into specified rows and columns.
Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, data summaries created via PIVOTBY automatically update to reflect changes in your original data, and you can customize what they show by tweaking the formula.
