duplicate lines
Morning.
I have attached the Raw DATA which has had unnecessary rows removed, I need to remove duplicate lines of product while at the same time Suming the total units for each product, I need to be able to apply this to the entire sheet all at once. i have tried the consolidate functions in excel however these don't seem to work.
i.e.
product 42494 - Ref SB-519338 - Qty 3
product 42494 - Ref SB-519338 - Qty 6
changed to
product 42494 - Ref SB-519338 - Qty 9
this is because this information is then pasted into a sheet that breaks down the pack sizes and returns the total picks, this means if i have more than 1 line for the same product on the same order the total picks will be incorrect as the sheet will work out the 3 and then the 6 rather than working out 9.
i.e. the above might come in a pack of 9 so the sheet will return 3 inner picks for line 1 and 6 inner picks for line 2 rather than 1 full carton pick.
I hope I have made it clear enough for you to be able to help.
Thank you heaps.
|