Power Query in Excel - How to display outcome as if a pivot table is used

Question

How do I use Power Query in Excel to transform Table 1 to Table 2? Thanks

Table 1:

Table 2:

Answer 1

Excel 365 Pro Plus with Power Pivot and Power Query.
...display outcome as (if) a pivot table is used...
With Pivot Chart and Slicer.
https://www.mediafire.com/file_premium/l79eqtywpb1lcew/08_28_23.xlsx/file
https://www.mediafire.com/file_premium/e0sqvpm5n1ro5s5/08_28_23.pdf/file