Hello everyone,

I am trying to merge two data set by their unique string variables. However, these two datasets do not share the same format for their string value.

For example,

Data set 1:
Year CEO NAME FIRM NAME
1995 Jonny Dan AAA Company
1995 Tommy Z BBB Company
1995 Jacky Young Ccc Company
1995 Bill Morgan ddd Company







Data set 2:
Year CEO NAME FIRM NAME
1995 Jonh Daniel AAA
1995 Tom Zeus BBB Firm
1995 JACKY YOUNG Ccc Corporation
1995 William Morgan DDD Company








So if I want to merge these two data set by CEO name and Firm name. How should I write the code?

Thanks in advance