How to compare two datasets with one column in common

[Stevebobs]

Hi everyone, 

I'm looking to compare two datasets such as: 

First excel dataset A has: 

Column A - with a list of clients

Column B - with a list of employees within these clients

Column C - with a list of revenue generated per employee within these clients 

Second excel dataset B has the same format. 

My goal is to have the output as the following: 

Column A - list of clients 

Column B - list of employees from dataset B within clients from column A 

Column C - list of revenue generated per employee from dataset B 

Column D - list of employees from dataset A 

Column E - list of revenue generated per employee from dataset A 

Let me know if that's unclear and I can provide a visual example! 

Thank you! 

Steve

[Robin_McIntosh]

So your desired output would look something like this?

[binuacs]

@Stevebobs Can you provide sample input files and expected output result in an excel?

[Stevebobs]

Hi @Robin_McIntosh, 

Thanks for the reply! :) 

That's the idea - in an ideal world:

With a top or bottom row that sums up the revenue per client, and also with matching employees on the same rows for an easier comparison. See screenshot: 

Best,
Steve

[Stevebobs]

Hi @Binuacs, 

Sure, here it is. 

Best,
Steve