Replace duplicated values with average in Power Query

[amethyst_tang_2]

Hi, in this scenario, i have 3 duplicates, and among all these 3 duplicates, all has the same values except for the score, where each duplicate have a different score. is there any way in power query, where i can find the average of these 3 scores, then followed by removing the duplicated rows. 

attached an image for reference.

[PijushRoy]

Hi @amethyst_tang_2 

Please use Group by with the Overview column
and Avg for the other 4 numeric column
Example

If your requirement is solved, please make sure to MARK AS SOLUTION and help other users find the solution quickly. Please hit the LIKE button if this comment helps you.

Thanks
Pijush
www.MyAccountingTricks.com 
https://www.youtube.com/MyAccountingTricks

[amethyst_tang_2]

Hi PijushRoy, have tried the groupby method. However, it seems that I can only combine the 3 values together.

however, i hope that i am able to remove those duplicated values then replace with the average, all doen via Power Query. Do you think there are any way to solve this?

[amethyst_tang_2]

Hi, do you have any idea, after getting the average value, how do i put the value back to the original data and remove the other duplicated rows then?