1, select the data range;
2. Menu: Insert-Pivot Table;
3. Click the PivotTable report, and a field list interface will appear on the side, where you can drag the item number and specification into the row label; The specification code is dragged into the column label; Inventory is dragged into value;
4. Adjust the format:
Right-click the category summary row of the PivotTable report to uncheck the category summary;
Right-click PivotTable-PivotTable Options-Show-Check Classic Layout