Multiple categories based on keywords and values

[DisMissive]

Hey folks,
Kinda new to this excel thingy so excuse me for being dumb
I have about 40,000 products and over 60 categories (or more based on how things are going)
is it possible to use a set of defined texts as keywords and show them as categories with , between them?

ex: if this cell have these kw in it then show these categories
another pic:
if this cell have caps in it then show hoodwear,caps,hat,etc
Any ideas?

and thanks in advance for help!

 

[DeficientOptimism]

If we could see a sample of the data it would be easier to write some formulas to categorize for you

 

[DisMissive]

so here is a quick overview of the file.
See دسته بندی that's the categories I want to sort as multiple categories.

There would be some other keywords and as they are so many of them I would not know if it works in anyway
and there are some for example

Categories​	Keyword​	Keyword​
سنسور,سنسور دریچه گاز, قطعه یدک​	سنسور​	دریچه گاز​