Spreadsheet: 129144d1321469091-sum-all-rows-that-have-the-same-identifier-in-adjacent-column-excel-problem
Sheet: Sheet1

Sector | Occupation name | Number | Agriculture | Banking & Finance
Agriculture | managers and senior officials | 385.445 |  |  |  | Agriculture
Agriculture | administrative and secretarial | 311.391 |  |  |  | Banking & Finance
Agriculture | process, plant and machine operatives | 1027.04 |  |  |  | Construction
Agriculture | elementary occupations | 3492.07 |  |  |  | Distribution & Hospitality
Energy/Water | managers and senior officials | 367.842 |  |  |  | Energy/Water
Energy/Water | professional occupations | 289.539 |  |  |  | Manufacturing
Energy/Water | associate professional and technical | 356.309 |  |  |  | Other services
Energy/Water | process, plant and machine operatives | 1197.61 |  |  |  | Public Administration, Educ, Health
Energy/Water | elementary occupations | 599.716 |  |  |  | Transport & Communication
Manufacturing | managers and senior officials | 2615.56
Manufacturing | professional occupations | 6053
Manufacturing | associate professional and technical | 1588.52
Manufacturing | administrative and secretarial | 915.356
Manufacturing | skilled trades occupations | 5628.71
Manufacturing | sales and customer service occupations | 513.522
Manufacturing | process, plant and machine operatives | 13803.2
Manufacturing | elementary occupations | 18356.3
Construction | managers and senior officials | 862.547
Construction | professional occupations | 1296.55
Construction | associate professional and technical | 926.282
Construction | administrative and secretarial | 1408.24
Construction | skilled trades occupations | 5120.65
Construction | elementary occupations | 1670.46
Distribution & Hospitality | managers and senior officials | 4122.74
Distribution & Hospitality | associate professional and technical | 2296.28
Distribution & Hospitality | administrative and secretarial | 1649.83
Distribution & Hospitality | skilled trades occupations | 5204.42
Distribution & Hospitality | personal service occupations | 1121.74
Distribution & Hospitality | sales and customer service occupations | 20250.7
Distribution & Hospitality | process, plant and machine operatives | 5888.51
Distribution & Hospitality | elementary occupations | 53729.8
Transport & Communication | managers and senior officials | 2739.39
Transport & Communication | professional occupations | 8612.72
Transport & Communication | associate professional and technical | 5977.13
Transport & Communication | administrative and secretarial | 863.154
Transport & Communication | skilled trades occupations | 760.571
Transport & Communication | personal service occupations | 248.263
Transport & Communication | sales and customer service occupations | 644.634
Transport & Communication | process, plant and machine operatives | 1908.41
Transport & Communication | elementary occupations | 13936.7
Banking & Finance | managers and senior officials | 5721.58
Banking & Finance | professional occupations | 10639.5
Banking & Finance | associate professional and technical | 11940.9
Banking & Finance | administrative and secretarial | 4663.58
Banking & Finance | skilled trades occupations | 1504.75
Banking & Finance | personal service occupations | 1949.08
Banking & Finance | sales and customer service occupations | 2673.23
Banking & Finance | process, plant and machine operatives | 1345.11
Banking & Finance | elementary occupations | 16727.7
Public Administration, Educ, Health | managers and senior officials | 1780.33
Public Administration, Educ, Health | professional occupations | 17312.9
Public Administration, Educ, Health | associate professional and technical | 7206.3
Public Administration, Educ, Health | administrative and secretarial | 6457.87
Public Administration, Educ, Health | personal service occupations | 24794.1
Public Administration, Educ, Health | sales and customer service occupations | 806.096
Public Administration, Educ, Health | process, plant and machine operatives | 364.2
Public Administration, Educ, Health | elementary occupations | 5551.02
Other services | managers and senior officials | 3106.63
Other services | professional occupations | 743.575
Other services | associate professional and technical | 5533.41
Other services | administrative and secretarial | 783.637
Other services | skilled trades occupations | 965.13
Other services | personal service occupations | 4588.31
Other services | process, plant and machine operatives | 384.838
Other services | elementary occupations | 1822.21