Build A Pivot Table to Summarize the Data

Now it’s a simple matter of throwing the Item Name in the Rows section and the quantity in the Data section.