I was drowning in XLOOKUP formulas, but Power Pivot gave me a cleaner way to build reports.

A pivot table is a statistics tool that summarizes and reorganizes selected columns and rows of data in a spreadsheet or database table to obtain a desired report. The tool does not actually change ...