Adding Duplicates and deleting duplicate rows

Thanks for looking at my post.
Any help will be much appreciated and thanks again for your time and effort.

I have two sheets

Sheet1 and sheet2

I would like sheet1 to be like sheet2 please. Sheet2 is the result what i am looking for tbh
Basically, I have number with sometimes its duplicating. I have added formula in column F if it is duplicate or not.
If it is duplicate then i would like to add corresponding column in respect to number and delete the duplicate.
That is for example, number 3 is repeating three times. In this case column B will be 15, Column C will be 28 (15+9+4), column D will be 16 (0+12+4), column E will be 30 (10+8+12)
After adding rest of the 2 duplicate need to get deleted and leaving only one time 3 rather than three times please.

Hope i explained it. If not please let me know.

Thanks again