How to match inputs to a list of category Power Query

[donkeyeminence]

Column A are all the different types of inputs that could be related to a particular category.

How can I do it in such a way that my output becomes something like this?

[wdx223_Daniel · Accepted solution]

NewStep=let a=Table.ToList(Table2,each {Text.Split(_{0},","),_{1}}) in Table.AddColumn(Table1,each Text.Combine(List.Zip(List.Select(a,(x)=>List.Contains(x{0},[Others],(x,y)=>Text.Contains(y,x)))){1},","))

[donkeyeminence]

oh my goodness, it works thank you so much! Could you explain how the code works?