Excel PivotBy function – use multiple fields in rows and columns

Use the new, powerful PivotBy function in Excel It replaces Pivot tables in many cases. To use multiple fields, you need to either use table syntax or HSTACK function.

Download Sample file

    GetPivotData macro – Copy from pivot and paste as GetPivotData

    Pivot Table Settings You Did Not Know!

    Distinct count and custom layout in Pivot Table – using Data Model

    Beyond AutoFilter – Use Slicers to filter Excel data and pivot tables

    Queries | Comments | Suggestions | Wish list