Greetings,
I have 2 tables and i want to compare their data in a sheet but their primary keys is their name but in the other table the name is longer and sometime does not contain upper case.
| Name | Year |
|---|
| Francis | 1995 |
| Denis | 1985 |
| Jean | 1975 |
| Name | Age |
|---|
| Francis Lalan | 22 |
| denis Rousseau | 39 |
If i want to have a table like this, is there any partial matching way to do it ?
| Name | Age | Year |
|---|
| Francis | 22 | 1995 |
| Denis | 39 | 1985 |
| Jean | | 1975 |
