Spreadsheet: 845875d1697195873-merge-columns-in-power-query-merge-columns-in-power-query
Sheet: Data

Employee | Emp ID | Work order Number 1 | Work order [NAME] | Week Number | Days | Work Order Number 12 | Work order [NAME] | Oct-2023 | Nov-2023 | Dec-2023 | Jan-2024 | Feb-2024 | Mar-2024
Jererome | UKJMA003 | 70009391-222 | 1US Stage 2R - Energy and Sustainability | 202340 | 1.533333333333333
Jererome | UKJMA003 |  |  |  |  | 70108172-211 | Barclays Paris - Operational Energy & TM54 | 4 | 3 | 2 | 9 | 0 | 0
Jererome | UKJMA003 | 70087403-E20 | [NAME] Stage-2 | 202340 | 2
Jererome | UKJMA003 |  |  |  |  | 70107938-BPG | [NAME] and WLC | 2 | 0.25 | 0 | 0 | 0 | 0
Jererome | UKJMA003 | 70087403-E20 | [NAME] Stage-2 | 202340 | 0.1333333333333333
Jererome | UKJMA003 |  |  |  |  | 99900014-001 | Team 09 Annual Leave | 5 | 0 | 3 | 0 | 0 | 0
Jererome | UKJMA003 | 70107938-BPG | [NAME] and WLC | 202340 | 0.4
Jererome | UKJMA003 |  |  |  |  | 70110010-211 | Barclays Monaco - Operational Energy TM54 | 0.5 | 0 | 0 | 2.5 | 2 | 2
Jererome | UKJMA003 | 70107938-BPG | [NAME] and WLC | 202340 | 0.3333333333333333
Jererome | UKJMA003 |  |  |  |  | 70046361-2WL | 206 Marylebone Road - Stage 2 - WELL and [NAME] | 0 | 1 | 0.5 | 0 | 0 | 0
Jererome | UKJMA003 | 70009391-222 | 1US Stage 2R - Energy and Sustainability | 202340 | 0.6
Jererome | UKJMA003 |  |  |  |  | 70009391-222 | 1US Stage 2R - Energy and Sustainability | 4 | 2 | 0 | 0 | 0 | 0
Jererome | UKJMA003 |  |  |  |  | 70090296-251 | [NAME] | 1 | 0 | 0 | 0 | 0 | 0
Jererome | UKJMA003 |  |  |  |  | 70087403-E20 | [NAME] Stage-2 | 5 | 0.5 | 0 | 0 | 0 | 0
[NAME] | UKJPB012 | 70109143-BPG | Knaves Beech Business Centre Energy | 202340 | 1
[NAME] | UKJPB012 |  |  |  |  | 70099408-202 | NIKE Energy & Sustainability Stage 3 | 1 | 2 | 0 | 0 | 0 | 0
[NAME] | UKJPB012 | 70078613-D70 | OTC E&S RIBA Stage 3 Chairman's Scheme | 202340 | 1.6
[NAME] | UKJPB012 |  |  |  |  | 70097586-104 | 104 KPR South Stage E&S | 2 | 0 | 0 | 0 | 0 | 0
[NAME] | UKJPB012 | 70090296-251 | [NAME] Planing | 202340 | 1.733333333333333
[NAME] | UKJPB012 |  |  |  |  | 70103273-305 | Brookhill Estate  - E&S  S4a | 0 | 0 | 8 | 8 | 0 | 0
[NAME] | UKJPB012 | 99900011-001 | TRAINING RECEIVED: OTHER | 202340 | 0.6666666666666666
[NAME] | UKJPB012 |  |  |  |  | 99900014-001 | Team 09 Annual Leave | 0 | 0 | 3 | 0 | 0 | 0
[NAME] | UKJPB012 |  |  |  |  | 70112948-XXX | [NAME] | 0 | 4 | 5 | 0 | 0 | 0
[NAME] | UKJPB012 |  |  |  |  | 70078613-D70 | OTC E&S RIBA Stage 3 Chairman's Scheme | 3 | 3 | 3 | 3 | 3 | 0
[NAME] | UKJPB012 |  |  |  |  | 70046361-2ES | 206 Marylebone Road - Stage 2 - Project Sustainability Plan, E&S and Ene04 | 0 | 2 | 2 | 0 | 0 | 0
[NAME] | UKJPB012 |  |  |  |  | 70079905-3WE | 1 St [NAME] Assessment Stage 3 | 1 | 0 | 0 | 2.5 | 1.5 | 1.5
[NAME] | UKJPB012 |  |  |  |  | 70090296-251 | [NAME] | 4 | 1 | 0 | 0 | 0 | 0
[NAME] | UKJPB012 |  |  |  |  | 70087403-E20 | [NAME] Stage-2 | 3 | 1 | 0 | 0 | 0 | 0
[NAME] | UKAXC088 | 70078613-D70 | OTC E&S RIBA Stage 3 Chairman's Scheme | 202340 | 0.8666666666666667
[NAME] | UKAXC088 |  |  |  |  | 70106629-202 | 40LS Fitout - NABERS | 2 | 2 | 1 | 0 | 0 | 0
[NAME] | UKAXC088 | 70093557-410 | HSBC 8CS OSDP Works | 202340 | 0.2
[NAME] | UKAXC088 |  |  |  |  | 70106629-201 | 40LS Fitout - EPC | 2 | 2 | 2 | 6.95 | 0 | 0
[NAME] | UKAXC088 | 70096062-302 | 40 HOV-E&S Stage 3 | 202340 | 0.4666666666666667
[NAME] | UKAXC088 |  |  |  |  | 70102510-102 | Scania Normanton De Carb Modelling | 0 | 0 | 0 | 4 | 0 | 0
[NAME] | UKAXC088 | 70046361-2ES | 206 Marylebone Road - Stage 2 - Project Sustainability Plan, E&S and ENE 04 | 202340 | 0.9333333333333333
[NAME] | UKAXC088 |  |  |  |  | 70107808-ES3 | Haynes Park - E&S - Stage 3 | 0 | 0 | 7.5 | 0 | 0 | 0
[NAME] | UKAXC088 | 99900002-001 | TIME - BUSINESS LEADERSHIP | 202340 | 0.4666666666666667
[NAME] | UKAXC088 |  |  |  |  | 99900014-001 | Team 09 Annual Leave | 0 | 0 | 3 | 0 | 0 | 0
[NAME] | UKAXC088 | 70030943-811 | E&S Team – EPC D2,E,F | 202340 | 1.4
[NAME] | UKAXC088 |  |  |  |  | 70112948-XXX | [NAME] | 0 | 1 | 1 | 0 | 0 | 0
[NAME] | UKAXC088 | 70090296-251 | [NAME] Planing | 202340 | 0.6666666666666666
[NAME] | UKAXC088 |  |  |  |  | 70109143-BPG | Unit A, [NAME], Business Centre | 0 | 0 | 0 | 1 | 0 | 0
[NAME] | UKAXC088 |  |  |  |  | 70096062-502 | 40 High Holborn - NABERS Stage 3 | 2 | 2.5 | 3 | 4 | 4 | 4
[NAME] | UKAXC088 |  |  |  |  | 70067636-E05 | Seal House - E&S S4 | 1 | 2 | 2 | 2 | 0 | 0
[NAME] | UKAXC088 |  |  |  |  | 70046361-2ES | 206 Marylebone Road - Stage 2 - Project Sustainability Plan, E&S and Ene04 | 2 | 2 | 2 | 2 | 0 | 0
[NAME] | UKAXC088 |  |  |  |  | 70030943-811 | E&S Team – EPC D2,E,F | 3 | 3 | 0 | 0 | 0 | 0
[NAME] | UKAXC088 |  |  |  |  | 70078613-D70 | OTC E&S RIBA Stage 3 Chairman's Scheme | 3 | 3 | 3 | 3 | 3 | 0
[NAME] | UKAXC088 |  |  |  |  | 70096062-302 | 40 High Holborn - E&S Stage 3 | 2 | 3 | 4 | 4 | 4 | 4
[NAME] | UKAXC088 |  |  |  |  | 70090296-251 | [NAME] | 3.5 | 1 | 0 | 0 | 0 | 0
[NAME] | UKAXC088 |  |  |  |  | 70079905-3WE | 1 St [NAME] Assessment Stage 3 | 1 | 0 | 0 | 1.5 | 1 | 0
Jakub | UKJAC007 |  |  |  |  | 70106629-202 | 40LS Fitout - NABERS | 0.5 | 0.5 | 0 | 0 | 0 | 0
Jakub | UKJAC007 |  |  |  |  | 70107546-BPG | Greencore - Springfield Meadows POE | 0.25 | 0 | 0 | 0 | 0 | 0
Jakub | UKJAC007 |  |  |  |  | 70102899-E20 | 4 Portal Way- E&S Stage 2 | 0.2 | 0.2 | 0.2 | 0 | 0 | 0
Jakub | UKJAC007 |  |  |  |  | 70106629-201 | 40LS Fitout - EPC | 1 | 1 | 1 | 0 | 0 | 0
Jakub | UKJAC007 |  |  |  |  | 70108172-211 | Barclays Paris - Operational Energy & TM54 | 0.2 | 0.5 | 1 | 2.5 | 0.5 | 0
Jakub | UKJAC007 |  |  |  |  | 70111537-103 | Muse MOD DBS Offices - RIBA 2 | 0 | 0 | 0 | 3 | 0 | 0
Jakub | UKJAC007 |  |  |  |  | 99900014-001 | Team 09 Annual Leave | 2 | 0 | 3 | 0 | 0 | 0
Jakub | UKJAC007 |  |  |  |  | 70109143-BPG | Unit A, [NAME], Business Centre | 0 | 0 | 0 | 1.81 | 0 | 0
Jakub | UKJAC007 |  |  |  |  | 70110010-211 | Barclays Monaco - Operational Energy TM54 | 0.25 | 0.5 | 0.1 | 0.25 | 0.5 | 0.1
Jakub | UKJAC007 |  |  |  |  | 70097586-104 | 104 KPR South Stage E&S | 0.5 | 0 | 0 | 0 | 0 | 0
Jakub | UKJAC007 |  |  |  |  | 70064563-5MN | 40 Leadenhall Street - Energy | 4 | 4 | 0 | 0 | 0 | 0
Jakub | UKJAC007 |  |  |  |  | 70067636-E05 | Seal House - E&S S4 | 3 | 3 | 3 | 3 | 0 | 14.85
Jakub | UKJAC007 |  |  |  |  | 70009391-222 | 1US Stage 2R - Energy and Sustainability | 2 | 1 | 0 | 0 | 0 | 0
Jakub | UKJAC007 |  |  |  |  | 70030943-811 | E&S Team – EPC D2,E,F | 0.5 | 0.5 | 0 | 0 | 0 | 0
Jakub | UKJAC007 |  |  |  |  | 70077335-011 | 1 Portal Way E&S | 0 | 0 | 0 | 0.5 | 0 | 0
Jakub | UKJAC007 |  |  |  |  | 70089138-XXX | Inter Office [NAME] and Bristol | 2 | 0 | 0 | 0 | 0 | 0
Jakub | UKJAC007 |  |  |  |  | 70096062-502 | 40 High Holborn - NABERS Stage 3 | 0 | 0 | 0.5 | 0.5 | 0.5 | 0.5
Jakub | UKJAC007 |  |  |  |  | 70078613-D70 | OTC E&S RIBA Stage 3 Chairman's Scheme | 1 | 1 | 1 | 1 | 1 | 0
Jakub | UKJAC007 |  |  |  |  | 70086310-F13 | NHS St Leonards EPC | 0 | 0 | 0 | 2.9 | 0 | 0