i have the following table,
i would like to sum all duplicates quantaty , and if possible delete them after

any idea on how, i'm a rookiein excel

thanks in advaance

Product / qty

1 4040 300
2 4040 345
3 4209 165
4 4209 200
5 4263 178
6 4270 71
7 4305 106
8 4306 32
9 4306 -32
10 4602 350
11 4603 528
12 4603 90



PS, its a very long table , i tried an IF but it requires to entere each product , ant that will take long time