Share via

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

nic2023 0 Reputation points
2023-08-27T23:08:18.6133333+00:00

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

Table 1: User's image

Table 2:User's image

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,013 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,735 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Herbert Seidenberg 1,191 Reputation points
    2023-08-29T02:14:35.83+00:00

    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

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.