Question: How to create a pivot table using the following headcount to group workers in skilled, unskilled and executive? Year of Hire (All) Count of Job
How to create a pivot table using the following headcount to group workers in skilled, unskilled and executive?
| Year of Hire | (All) | ||||||
| Count of Job Title | Column Labels | ||||||
| Row Labels | Basic-Skilled | Professional | Semi Skilled | Senior Management | Skilled | Supervisory/ Middle Management | Grand Total |
| Account Manager | 1 | 1 | |||||
| Accounts Clerk | 1 | 1 | 2 | ||||
| Assistant Project Manager | 1 | 1 | |||||
| Banksman | 56 | 2 | 58 | ||||
| Base Foreman | 15 | 15 | |||||
| Base Lifting Technician | 2 | 2 | |||||
| Base Manager | 6 | 1 | 7 | ||||
| Base Supervisor | 3 | 3 | |||||
| Business Development Manager | 1 | 1 | |||||
| CAD Engineer | 2 | 2 | |||||
| Chief Accountant | 1 | 1 | |||||
| Chief Financial Officer | 1 | 1 | |||||
| Cleaner | 3 | 3 | |||||
| Commercial Support Administrator | 1 | 1 | |||||
| Company Lawyer & Corporate Secretary | 1 | 1 | |||||
| Construction and Maintenance Manager | 1 | 1 | |||||
| Construction Foreman | 1 | 1 | 3 | 5 | |||
| Construction Manager | 2 | 2 | |||||
| Construction Operator | 1 | 1 | 2 | ||||
| Construction Project Manager | 1 | 1 | |||||
| Construction Project Superintendent | 1 | 1 | |||||
| Construction Superintendent | 1 | 1 | |||||
| Construction Supervisor | 1 | 1 | |||||
| Continuous Improvement Coordinator | 1 | 1 | |||||
| Contracts Support Administrator | 1 | 1 | |||||
| Corporate Communications Officer | 1 | 1 | |||||
| Crane Operator | 1 | 12 | 13 | ||||
| Customs Broker | 1 | 1 | |||||
| Data Entry Clerk | 1 | 1 | |||||
| Deputy Supply Chain Manager | 1 | 1 | |||||
| Document Controller | 1 | 1 | |||||
| Driver | 6 | 1 | 7 | ||||
| Electrical Attendant | 1 | 1 | 2 | ||||
| Electrical Foreman | 1 | 1 | |||||
| Electrician | 1 | 3 | 4 | ||||
| Electronic Technician | 1 | 1 | |||||
| Executive Secretary | 1 | 1 | |||||
| Exxon Support Administrator | 1 | 1 | |||||
| Financial Controller | 1 | 1 | |||||
| Fitter | 9 | 9 | |||||
| Fleet Manager | 1 | 1 | |||||
| Fleet Supervisor | 1 | 1 | |||||
| Forklift Operator | 29 | 29 | |||||
| Front Desk Administrator | 1 | 1 | |||||
| Fuel Bunkering Maintenance Technician | 1 | 1 | |||||
| Fuel Bunkering Operation Supervisor | 1 | 2 | 3 | ||||
| Fuel Bunkering Operator | 3 | 6 | 9 | ||||
| General Labourer | 14 | 14 | |||||
| General Manager | 1 | 1 | |||||
| General Manager's Assistant | 1 | 1 | |||||
| GIE Electrical Technician | 1 | 1 | |||||
| GIE Electrician Technician | 1 | 1 | |||||
| Government Liaison Manager | 1 | 1 | |||||
| Heavy Duty Operator | 3 | 37 | 40 | ||||
| Housekeeper | 10 | 10 | |||||
| Human Resource Manager | 1 | 1 | |||||
| Human Resource Officer | 2 | 2 | |||||
| HVAC Installer | 1 | 1 | |||||
| Information Technology Manager | 1 | 1 | |||||
| Information Technology Support Officer | 2 | 2 | |||||
| Lifting Coordinator | 2 | 3 | 5 | ||||
| Local Content Compliance Officer | 1 | 1 | |||||
| Logistics Coordinator | 1 | 1 | |||||
| Logistics Supervisor | 5 | 5 | |||||
| Logistics Support Administrator | 1 | 1 | |||||
| Maintenace Coordinator | 1 | 1 | |||||
| Maintenance Foreman | 1 | 1 | |||||
| Maintenance superintendent | 2 | 2 | |||||
| Maintenance Support Administrator | 1 | 1 | |||||
| Maintenance Technician | 2 | 2 | |||||
| Mechanical Foreman | 1 | 1 | |||||
| Mechanical Maintenance Attendant | 8 | 11 | 19 | ||||
| Medic | 3 | 3 | |||||
| Operation Support Administrator | 3 | 3 | |||||
| Operations Assistant | 103 | 1 | 104 | ||||
| Operations Manager | 1 | 1 | |||||
| Operations Manager Assistant | 1 | 1 | |||||
| Payroll Accountant | 1 | 1 | |||||
| Payroll Assistant | 1 | 1 | |||||
| Procurement Officer | 2 | 2 | |||||
| Procurement Supervisor | 1 | 1 | |||||
| Project Engineer | 1 | 1 | |||||
| Project Manager | 1 | 4 | 5 | ||||
| QA/QC Field Inspector | 1 | 1 | |||||
| QHSSE Officer | 5 | 27 | 1 | 33 | |||
| QHSSE Supervisor | 4 | 4 | |||||
| Records Clerk | 1 | 1 | |||||
| Senior Base Manager | 1 | 1 | |||||
| Site Lifting Coordinator | 1 | 1 | |||||
| Staff Accountant | 2 | 2 | |||||
| Surveyor | 1 | 1 | |||||
| Technical Assistant | 1 | 1 | |||||
| Technical Coordinator | 1 | 1 | |||||
| Technical Electrician | 2 | 2 | |||||
| Technical Maintenance Manager | 1 | 1 | |||||
| Technical Procurement Officer | 1 | 1 | |||||
| Training Coordinator | 1 | 1 | |||||
| Training Officer | 1 | 1 | 2 | ||||
| Truck Driver | 1 | 1 | |||||
| Warehouse Attendant | 1 | 1 | |||||
| Warehouse Clerk | 1 | 1 | |||||
| Warehouse Officer | 2 | 1 | 3 | ||||
| Warehouse Operator | 1 | 1 | |||||
| Warehouse Supervisor | 4 | 4 | |||||
| Water Bunkering Foreman | 1 | 1 | |||||
| Water Bunkering Operator | 5 | 5 | |||||
| Water Front Development Manager | 1 | 1 | |||||
| Grand Total | 217 | 23 | 23 | 23 | 177 | 52 | 515 |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help