I am analyzing a large database. In column €œA€� is a list of employee names,
each appearing multiple times according to how many jobs they have done. In
column €œB€� is the type of jobs they have done, of which there are three
types, indicated by letters: €œC€�, €œW€� and €œI€�.
What I am trying (But failing) to accomplish is to determine how many times
employee €œJoe Employee€� has done each type of job. Any help would be
appreciated.
The output that I am looking for would look something like this:

Employee C W I
Joe Employee 25 10 15