Combine two data sets and merge them into one table

Hi,

I post this problem here, but no luck yet.

I have two different data sets but they have this shared ID which is the employee name.
I want to combine these two data sets and listing them by name in a table.

In the attachment I tried to portray my problem with the solution (combined table) I am looking for.

I tried the consolidate function, but i guess that this is not the solution. I guess I should use a advanced version of Vlookup function

Any suggestion is welcome

Thanks xladept,

It's a great starting point. May be it's my fault for not being clear enough. Your solution does not correctly use the second data set.
For example Alex has one instances in data set 1 and three instances data set 2. Currently your solution uses only the first entry of data set 2.

For Alex should the result in Combined table be like this:
combined_table.png
The Combined table will be used eventually for running reporting per person.

Hi Xladept,

Yes I am telling you the whole story. With the help of someone else, we managed to get the result. It needs some testing but this is what I was asking:

Please Login or Register  to view this content.