Merging col items in a single cell for each row item

Hello,

Hope you are doing fine.

I have an example for which i would require a macro to solve, attaching the example file for your reference.

There are prod. plant codes in Col A and in row 1 we have 12 products codes. For each plant code if we find matched products then we are suppose to merge the product codes in a single cell next to Plant code. it'll clear when you see the attached excel file.

Regards,
Rajkumar