Filtering and combining into a datastore

I need to take the data in the CSV and move it to a data store. You will see that there are multiple lines for each order number. How would I go about getting only 1 unique record in the data store for each order number but sum up the quantity for each one?
I have mocked up what i am trying to achieve in excel for clarity.

It has been suggested to use google sheets or airtable but i would prefer just to keep it within Make if possible.

Screenshot 2024-01-10 085915-1

Welcome to the Make community!

Please paste your CSV data, or upload it here, or share a link to it.