Spreadsheet: 870345d1716884445-formula-to-pull-data-from-list-and-populate-in-row-sample-workbook
Sheet: Sheet2

Employee Number | Staff Name | [NAME] | Business Unit | Office Location | Discipline | Skill Area | [NAME] | Current Skill Level
12222 | Employee one | Ground Engineering - Geology | 123abc | Here | Construction Management | Roadway Inspection | Earthwork / Base Inspection | 5
12222 | Employee one | Ground Engineering - Geology | 123abc | Here | Construction Management | Plan Inspection | Water Treatment Plant Inspection | 4
12222 | Employee one | Ground Engineering - Geology | 123abc | Here | Construction Management | Construction Supervision | Groundworks | 4
12222 | Employee one | Ground Engineering - Geology | 123abc | Here | Construction Management | Construction Management | CM on highway / roadway projects | 4
12222 | Employee one | Ground Engineering - Geology | 123abc | Here | Program Management | Programme Management | Lead Weekly/Daily Construction Meetings | 4
12222 | Employee one | Ground Engineering - Geology | 123abc | Here | Program Management | Programme Management | Leading Teams | 4
12222 | Employee one | Ground Engineering - Geology | 123abc | Here | Construction Management | Health, Safety and Environment | [NAME] | 4
12223 | Employee two | Project Management | 123abc | Here and There | Project Management | Project Management | Manage Stakeholder Engagement | 5
12223 | Employee two | Project Management | 123abc | Here and There | Project Management | Project Management | [NAME] | 5
12223 | Employee two | Project Management | 123abc | Here and There | Project Management | Project Management | RFP Development | 5
12223 | Employee two | Project Management | 123abc | Here and There | Project Management | Project Management | Stakeholder Management | 5
12223 | Employee two | Project Management | 123abc | Here and There | Project Management | Project Management | Monitor Stakeholder Engagement | 5
12223 | Employee two | Project Management | 123abc | Here and There | Project Management | Project Management | Project Execution Plan | 5
12223 | Employee two | Project Management | 123abc | Here and There | Project Management | Project Management | Project Management | 4
12223 | Employee two | Project Management | 123abc | Here and There | Project Management | Project Management | Project Procedure Development | 4
12223 | Employee two | Project Management | 123abc | Here and There | Project Management | Project Management | Performance Management | 3
12223 | Employee two | Project Management | 123abc | Here and There | Project Management | Project Management | Plan Stakeholder Engagement | 1
12223 | Employee two | Project Management | 123abc | Here and There | Project Management | Project Management | Team Training | 1
Employee Number | Staff Name | [NAME] | Business Unit | Office Location | Discipline | Skill Area | [NAME] | Secondary Skill | Tertiary Skill
12222 | Employee one | Ground Engineering - Geology | 123abc | Here | Construction Management | Roadway Inspection | This should reflect H2 | This should reflect H3 | This should reflect H4
12223 | Employee two | Project Management | 123abc | Here and There | Project Management | Project Management | This should reflect H9 | This should reflect H15 | This should reflect H17