Total of quantities for unique parts that repeat at random

Hi Experts,

Apologies as I am sure this is a relatively frequently asked question, but I don't know what to search for to find the answer!

I have an order form that amalgamates all orders into a list and the respective quantites.
The parts and qtys are simply added to the bottom of the list.
The parts are not in the same case format (some are All lowercase, some uppercase or some are capitalised, some contain spaces before or after the part number).

What I ideally would like is the list to only show the total quantities for each unique part.

Attached is a sample.

Thanks as usual for any responses.