UNIQUE WORD in each row.

Question

Hi All,

I need help in removing duplicates and selecting only unique words from each row.

I am able to do it for limited rows, but what if I have 25-30k rows.

I have attached the input which needs to be worked on and an example of what exactly I am looking for. Thanks in Advance.

Menu.xlsx

Capture.PNG

CKP · Accepted Answer

Hi @iamviraj13

I don't think I've found exactly what you're looking for but I think this is close.

Let me know if it helps

iamviraj13 · Accepted Answer

Figured out. Thanks. But would accept a more optimized solution.