Jul 15 2021 11:54 PM
Hi everyone,
Please refer attached image for context - I have 5 columns with duplicate values across all of them. I want to extract only the highlighted (in red) duplicates into one single column ( grey highlight) as unique entries.
What are the formulas and other methods I can use to do this?
Thank you,
K
Jul 16 2021 12:20 AM
@KnizEfl Haven't even tried doing this with formulae. PowerQuery seemed to be the easiest tool to achieve what you need. See a small example attached.