Data Analysis
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
|