Composite key

[Tanu]

The requirement is
Two columns (G and I), from sheet1 need to be taken as a single composite column (i.e. - row-5) and compared with each other key columns which is defined as Y (the composite key is always unique).
Now I want result to be show in concatenate way which is shown in below image( highlighted with yellow color in j column) need VBA code

 

[RoryA]

You have already been warned about this once. This is a duplicate of Concatenate the key column

Do not keep posting the same question or your posting privileges will be revoked.