Powerquery is a much more powerful alternative to pivot tables in modern excel. For one thing, you can chain queries, SQL style. IE, you can use the table that

Powerquery is a much more powerful alternative to pivot tables in modern excel. For one thing, you can chain queries, SQL style. IE, you can use the table that is the result of a query as input to another query.