How to combine only unique values for different columns

Hi o59393 

I think you probably want to do it

#"Grouped Rows" = Table.Group(#"Changed Type", {"ID"}, {
{"Sub Region", each Text.Combine(List.Distinct([Sub Region]),", "), type text}
,{"Region", each Text.Combine(List.Distinct([Region]),", "), type text}
,{"Country", each Text.Combine(List.Distinct([Country]),", "), type text}
})
in
    #"Grouped Rows"