Duplicate values

[Fidzi8]

Hi,

I have duplicate values in my data. 
I need SUM Delivery quantity (e.g. ID 310313809 = 23,80) and then delete duplicate values in column A. 

How do I do it in Power Query?

Thank you
Ondřej

[FarhanAhmed · Accepted solution]

Use Group By in Power Query

https://support.microsoft.com/en-us/office/group-rows-in-a-table-power-query-e1b9e916-6fcc-40bf-a6e8...

[amitchandak · Accepted solution]

@Fidzi8 , refer

https://www.poweredsolutions.co/2019/07/30/grouping-rows-with-power-bi-power-query/

[FarhanAhmed · Accepted solution]

Use Group By in Power Query

https://support.microsoft.com/en-us/office/group-rows-in-a-table-power-query-e1b9e916-6fcc-40bf-a6e8...