Matching columns from two data sets and joining the rows of the matched column

[gmurali]

I have two sets of data as shown below - 

                             

Final required result is as below - 

Any help or ideas would be much appreciated! Thanks in advance! 

[grazitti_sapna · Accepted solution]

Hi @gmurali , I believe this is what you are trying to achieve?

Thanks.

[gmurali]

Thanks a lot! This works! 

[grazitti_sapna]

@gmurali , if this solves your problem kindly mark this post as solved so that it can be helpful for other users as well looking for similar solutions.

Thanks.