Spreadsheet: 845884d1697200451-merge-columns-in-power-query-merge-columns-in-power-query_sample
Sheet: Append2

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