Forum Discussion
Solved
Concatenating field from different rows with same ID
I have a table like this ID Name 1 Anne 1 Bob 2 Cara 2 Doug 3 Ed 3 Fannie I want the table to look like this ID Names 1 Anne, Bob 2 Cara, Doug 3 E...
Hi
Group Column, choose "Sum" and replace List.Sum by Text.Combine
= Table.Group(Source, {"ID"}, {{"Data", eachList.Sum([Name]), type nullable text}})= Table.Group(Source, {"ID"}, {{"Data", each Text.Combine([Name],", "), type nullable text}})Stéphane
Hi
Group Column, choose "Sum" and replace List.Sum by Text.Combine
= Table.Group(Source, {"ID"}, {{"Data", each List.Sum([Name]), type nullable text}})= Table.Group(Source, {"ID"}, {{"Data", each Text.Combine([Name],", "), type nullable text}}) Stéphane
That worked! Thank you so much!
