Forum Discussion
Remove duplicate words in a cell after power query grouping and aggregating from a table
As variant you may aggregate ISO as sum, that will return an error, in formula bar will be something like this
Change in formula bar on that
Other words instead of List.Sum first List.Distinct to remove duplicates, on the top Text.Combine to have one string.
With that doesn't matter how many aggregations you have, you correct only specific one.
As variant you may aggregate ISO as sum, that will return an error, in formula bar will be something like this
Change in formula bar on that
Other words instead of List.Sum first List.Distinct to remove duplicates, on the top Text.Combine to have one string.
With that doesn't matter how many aggregations you have, you correct only specific one.
SergeiBaklan this worked perfectly, thanks!
As a follow up question, is it possible to add a step to the power query to re-order the ISO codes alphabetically in each cell?
OliverScheurich thank you! This also worked perfectly!
