Formula to find and match multiple values

Hi Gurus,

Would need your kind expertise to help on this request.

Assuming I’ve the following sample data as per attached and wishing if the expected output can be generated using some kind of excel/vba formulas.

The requirement is to find and match the specific cell which contains multiple values and return them in horizontal layout.

The sample data could be long and a lot, so it's best if the formula can be made flexible to cater for this situation.

Appreciate for any of your help and advice.

Thank you a lot in advance.