We have a bunch of data and need to remove all duplicate items, then create a concatenated list (comma separated). Which method is better - formulas or Power Query? In this video, I showcase both methods with comments on when you should select each one. Check it out.
#PowerQuery #RemoveDuplicates #DynamicArrayFunctions