Hi,

I have a table with unique identifier, and few columns (Job Run Length 1,2,..; Job Coverage 1,2,...).
I need to create a new table, that merges all the rows by their unique ID, while summing the Job Run Lengths and presenting the weighted average for the Job Coverage.

If it's too complicated to do so without coding, I would like to stay with same table, only with weighted average for the similar Job Id's Coverage.
In the below example, the last 2 rows (in theory there might be more than 2) should either merge to one with Job RL1 total of 11,137, weighted Coverage1 according to (7,281*143+3,856*76)/(7,281+3,856) - same for the next 2 columns, or stay in the same 2 rows only with updated weighted average for Job Coverage 1 in both rows.

Capture.PNG

Thank you all