Filter Column by Value, if dups Aggregate Rows to 1 Rows

Hi everyone,

I can really use help and appreciate it if anyone has an idea to the following

I am working with a spreadsheet that is raw data from a system, I need to aggregate rows of data if a condition is met.

Bassically, while filtering for dups, if it finds rows that are the same it would.
[1] SUM column E, display only the summed quantity in the new row.
[2] Column H, it would display the weighted average Value only.... To do this it would have to take SUMPRODUCT of (Column G x Column H) divided by SUM col E