Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)

CHAPTER 17. Pivoting without a pivot table using dynamic arrays or Power Query

In this chapter, you will learn how to create cross-tabular reports without using a pivot table:

• Use Advanced Filter and a Data Table

• Use Dynamic Arrays

• Use the Pivot command in Power Query

Before Microsoft called them pivot tables, the type of report with headings down the side and across the top was called a “cross-tabular report” or simply a “cross-tab report.”

Cross-tab reports existed before pivot tables. I regularly created them as part of my job in finance and accounting. After a couple of Advanced Filters, a transpose, a DSUM, and a Data Table, you were done. Pivot tables made all that simpler.

But today, 30 years after the invention of the pivot table, ...