Current location - Quotes Website - Personality signature - How to classify and summarize the data with the same name in another column under the same name in EXCEL table?
How to classify and summarize the data with the same name in another column under the same name in EXCEL table?
With excel20 10, insert the PivotTable report directly, and the final effect is as follows:

First, insert the PivotTable report and set it as follows:

After setting up, the perspective is still not ideal and needs to be beautified;

Click "design", as shown in the following figure

First, select Report Layout and Tabular Layout; Then select Subtotal and Don't Show Subtotal. It's over.