Merge Duplicate from Column and Add the Integers

[MTBradley]

Hello.

I would like to merge the duplicates in "Device Name" #1, and add the integers in column "Total (Sheets) #2". The other data can just be seperated by a comma.

I tried merge queries, but it did not return the results I needed. I am new at this and just may not understand how to use it yet.

Thank you in advance! 

[Anonymous · Accepted solution]

Hi @MTBradley ,

Here is my sample data:

Please use this M function to add a custom column:

let 
   currentDeviceName = [Device Name],
   allRows = Table.SelectRows(#"Changed Type", each [Device Name] = currentDeviceName),
   allTotals = allRows[#"Total (Sheets)"],
   concatenatedTotals = Text.Combine(List.Transform(allTotals, each Text.From(_)), ",")
in 
   concatenatedTotals

 And the final output is as below:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.