How to get the table working

[Anonymous]

Hi, 

In my power query i would like to to have the sum of all values in the Qty column and only showing one row for each obeject in the object column.

Ex: 815361 = 6

Any suggestions how to do it?

BR Patrik

[AntrikshSharma · Accepted solution]

@Anonymous Right click on the Object Column and select Group By

Then specify the Operation as Sum and choose the Qty column