2. Then click Data to find your saved file from the file, from the workbook, and from the file selection box that pops up.

3. In the navigator that pops up, select the file name on the left (not the worksheet below), and then click the conversion data on the lower right.

4. In the Power Query window that pops up, right-click the data column and click Delete other columns, as shown above.

Then click this Expand Data button and click OK.

5. Click to use the first line as the title, right-click the title in the table below, and then click Not Equal in the filter to delete the duplicate title. Finally, click the close upload button in the upper left corner to get the detailed summary table above.

6. Create 1 worksheets or workbooks, click Insert, pivot table, and select the summary details just generated, such as sheet 3! $A:$C

Check the name and situation on the right side of the line to summarize the data of the situation.

Then click Insert Slicer, tick the circle and confirm.

Click Week 1 at this time, and only the data of Week 1 will be displayed. Click Week 2 to display the data of Week 2. Hold down ctrl and select multiple weeks of data at the same time.