Cross-Highlighting across different rows

I have a table that shows candidate journeys in a job interview process:

id 1 shows they made an enquiry with no job preference but then they attended an interview where they decided on a job preference. then they decided to withdraw.

id 2 shows the same candidate changing their mind and their job preference and going into an assessment for that job. they then failed the assessment and were thus withdrawn again. 

id 3 shows the same candidate trying for another job and making it through.

they don't need to enquire again, nor do an interview if they were successful at those stages. however if they want to try for a different job they need to do an assessment for that job. 

I want to create 5 bar graphs showing the interaction between different job preferences. Unfortunately it ends up looking like this:


Here I clicked on "no preference" in the "candID by enquiry job pref" visual.
I understand this is a row context thing but I just can't figure out how to get 1 row to interact with another row based on a unique key, like their candidate id (candID).

What I want is for "no preference" in the enquiry stage to result in "baker" and "teacher" in assessment stage increasing by 1. Join pref should increase by 1 for "teacher" and withdrawal should end up with 1 for "baker".

I don't want to fill in the blanks with the dates and preferences from the previous stages because that ends up in duplicates. Eg:


How do I make this happen like in the second screenshot but not showing the duplicates? Thank you 🙂