I have two excel sheets. I have to merge the two such that the values in one match with the other. For eg.

```
The first excel, the 2nd excel
1 t 1 tes1
2 5 3 tes3
3 t 4 tes4
4 g
```

Notice that in the first column of the 2nd excel, 2 is missing, so I want the first excel to look like this,

```
1 tes1 t
2 5
3 tes3 t
4 tes4 g
```

I am new to excel. Any help on this will be highly appreciated.