Find duplicates in a range and match corresponding values

Good morning all,

Each Dept. generates different revenue per hour of work. My end goal is to calculate the revenue generated per person per hour worked by weighting each person's revenue per hour against the amount of the hours they worked in each Dept. I understand how to create a weighted average, I can't figure out how to sort the data in a way that I can manipulate it however.

I am trying to take each value in [Name] range, search through [Name] for duplicate values, and retrieve each corresponding value in ranges [Dept.] and [Hours Worked] when duplicates exist. If I could get a result like the one shown below, I could solve the rest of my problem.

Thank you,

Joe