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.