REMOVE DUPLICATES

BI and PQ DATA TIPS AND TRICKS

Remove duplicates from an individual cell

=Text.Combine (List.Distinct(List.Transform (Text.Split([EMAIL],","),each Text.Trim(_))),", ")