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.
