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