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

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!

Datasets

Accepted answers

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

Thanks.

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

Thanks.

Thanks a lot! This works!