How do I combine data accurately between two sheets based on shared column values? : Python may be the best bet for this I will upload a solution I will attempt but for you Excel experts I have a real bully of a problem for you.

```
Names 	Trophies
Scott	3
Jim	    3
Ron	    2
Bob	    1
Jack    1
```

now on sheet 2


```
Names	Age	Hobby
Bob	    1	fishing
Scott	 4	math
Jim	    6	chess
Ron	    2	tennis
    
```

the desired result is this


```
Names	Trophies Age	Hobby
Bob	    1        1	fishing
Scott	3        4	math
Jim	    3        6	chess
Ron	    2        2	tennis
Jack    1        1
    
```


Basically i want to match the names from both sheets together and combine their data accurately.

I am helpless, no idea.
