Join the data with multiple rows and shortcut Names in two data sets using Fuzzy logic

[kvr9]

Hi,

I got a requirement to join the data from excel in below format, kindly let me know the best approach to join the data based on the key and fetch the rest all data.

Kindly let me know if we need to use fuzzy logic? #data load  #joins