I have a spreadsheet that contains rows with multiple entries for the same
item. How can I use a filter or a function to combine the values for the
like items in to one row?

Example:
In the same chart, item number 40-011 appears three times with quantities of
5, 3, and 2. How can I filter the data so there is one occurence of 40-011
with a quantity of 10?