I've been asked to take a list and build it into a "report" like so many before me.
The goal here is to count the number of occurrences that an employee worked on a job, and then put that information into a matrix-style table with a single row for each job.
Below is a simple example of the starting data and the desired outcome. I've a little stumped on my formulas, trying to work with Max, If, Index, Match, CountIfs... and there's just something really wrong!
I also have more data available if it's easier to do the aggregation (counting) in excel rather than be presented with the sums already.

"where there is a match for a job number, first get the max and identify that employee and how many times he is present. then, identify the second most occurrences and the employee. Then the third. etc"

Starting Data:
1.PNG

Final Matrix:
2.PNG

Thanks!