View Full Version : Bringing together 2 sets of data

02-28-2019, 04:01 AM
Hi all,

I have to set of data. Both lists have a Employee reference which is unique to each person.

First: List of all positions people have ever had in the company with start and end date.

Second: List of all the salaries people have had within the company with a start and end date.

I need to bring this data together. However, if someone has had more than one salary between the start and end date of a position i need to insert a row with the same position details but each row will contain the 2 different salaries.

I have tried to do an example below.

Basically Employee 1 has had 2 positions but only 1 salary - so out the outcome they have 2 lines for each position but the same salary for both.

Employee 3 has had 2 positions but had a change in salary in the first one - so the outcome shows 2 lines for the first position because they had a salary change. Then the second position has one line because although its a new salary it started the same day as the position change.


I hope this makes sense. I just chant get my head round how to do this.


02-28-2019, 07:42 AM
Cross post https://www.mrexcel.com/forum/excel-questions/1089151-bringing-together-2-sets-data.html