Can you people help me with below query using a VBA code or excel formula (if it is feasible and doestn't take time).
I have data in sheet1 where there is ID in column "A" and category in Column "B". category will have multiple text separated by commas. Possible categories are - Production...