Hi XOR,

Each comma separated value in helper cell needs to be converted as each categ no.

I know its very strange to apply excel formula.

There is any other VBA code also would be fine.