Given the source data, how do you transform the middle PivotTable to appear like the rightmost PivotTable?
Right-click any row field value in the pivot table and select Group.
Below answer should be right
