Combine two tables over a same header

Hello there.

Starting off with an example:

Partner Table:

EMPLOYEE ID	PARTNER NAME	SOMETHING ELSE
123456	Ben	Yes
123789	John	Yes
123658	Michael	No

Employee Table:

EMPLOYEE ID	EMPLOYEE NAME
123789	Robert
123658	Sophia
123456	Kilian

Now I want to join those two tables into this:

EMPLOYEE NAME	EMPLOYEE ID	PARTNER NAME
Kilian	123456	Ben
Robert	123789	John
Sophia	123658	Michael

Can someone help me out with this one?
Note, that one Employee can have multiple Partners. If so, you should have a new row for each Partner, like: Sophia_123658_Tom; Sophia_123658_Daniel; etc..

Thank you so much!!!

Post an Excel sheet (see yellow banner - top) showing EXACTLY what you want when there are multiple partners for an employee. Otherwise, we're guessing.