Forum Discussion
Help with duplicates
I have a table with data as shown below. Can you help as how I can arrive at the desired output?
Input:
Desired Output:
=DROP(REDUCE("",UNIQUE(A1:A5),LAMBDA(a,b,VSTACK(a,HSTACK(b,TEXTJOIN(";",,UNIQUE(FILTER(B1:B5,A1:A5=b))),UNIQUE(FILTER(C1:C5,A1:A5=b)))))),1)
With Office 365 or Excel for the web you can use this formula.
