Spreadsheet: 871395d1717771827-trying-to-populate-a-row-from-merged-cells-with-a-helper-column-testing-heirarchy
Sheet: Proposed Org Structure - Hierar

Tier 1 | [NAME] | Tier 3 | [NAME] | Tier 5 |  | Department Name | Department Parent | Top Line Manager | Dept Head | Org Leader | Current Department / Sub-Department | Current Biz Control Mapping
R&D | Engineering |  |  |  |  | Engineering | R&D
 |  | Payroll Engineering |  |  |  | Payroll Engineering | Engineering
 |  |  | US Payroll |  |  | US Payroll | Payroll
 |  |  | PEO Engineering |  |  | PEO Engineering | Payroll
 |  |  | Global Payroll Engineering |  |  | Global Payroll Engineering | Payroll
 |  |  | Payroll Core |  |  | Payroll Core | Payroll
 |  |  | EOR Engineering |  |  | EOR Engineering | Payroll
 |  |  | Payroll Engines |  |  | Payroll Engines | Payroll
 |  |  |  | Payspace |  | Payspace | Payroll Engines
 |  |  | Contracts & ICs |  |  | Contracts & ICs | Payroll
 |  |  | Benefits |  |  | Benefits | Payroll
 |  | Mobility Engineering |  |  |  | Mobility Engineering | Engineering
 |  | Time & Attendance |  |  |  | Time & Attendance | Engineering
 |  | HRIS Engineering |  |  |  | HRIS Engineering | Engineering
 |  |  | [NAME] |  |  | [NAME] | HRIS Engineering
 |  |  | [NAME] |  |  | [NAME] | HRIS Engineering
 |  | Platform |  |  |  | Platform | Engineering
 |  |  | Integrations |  |  | Integrations | Platform
 |  |  | Onboarding |  |  | Onboarding | Platform
 |  | Finance & Payments |  |  |  | Finance & Payments | Engineering
 |  | Knowledge & Growth |  |  |  | Knowledge & Growth | Engineering
 |  | UI |  |  |  | UI | Engineering
 |  | Tech Excellence |  |  |  | Tech Excellence | Engineering
 | Infra |  |  |  |  | Infra | R&D
 |  | Infra Engineering |  |  |  | Infra Engineering | Infra
 |  | DevOps |  |  |  | DevOps | Infra
 |  | Database |  |  |  | Database | Infra
 | IT |  |  |  |  | IT | R&D
 | InfoSec |  |  |  |  | InfoSec | R&D
 | Product |  |  |  |  | Product | R&D
 | Data |  |  |  |  | Data | R&D
 |  | Data Science |  |  |  | Data Science | Data
 |  | Data & Analytics |  |  |  | Data & Analytics | Data
 |  | Product Analytics |  |  |  | Product Analytics | Data
 |  | Platform Operations |  |  |  | Platform Operations | Data
 |  | Integrations |  |  |  | Integrations | Platform
[NAME] | Customer Support & Services |  |  |  |  | Customer Support & Services | [NAME]
 |  | Customer Enablement |  |  |  | Customer Enablement | Customer Support & Services
 | Customer Success |  |  |  |  | Customer Success | [NAME]
 | Customer Onboarding |  |  |  |  | Customer Onboarding | [NAME]
 | Expansion Operations |  |  |  |  | Expansion Operations | [NAME]
 | Customer Operations |  |  |  |  | Customer Operations | [NAME]
 |  | Global Payroll |  |  |  | Global Payroll | Customer Operations
 |  | Payroll Implementation |  |  |  | Payroll Implementation | Customer Operations
 |  | PEO Operations |  |  |  | PEO Operations | Customer Operations
 |  | Immigration & Mobility |  |  |  | Immigration & Mobility | Customer Operations
 |  | HR Experience |  |  |  | HR Experience | Customer Operations
 |  | Global Service Center |  |  |  | Global Service Center | Customer Operations
 |  | FinTech Operations |  |  |  | FinTech Operations | Customer Operations
 | Operational Excellence |  |  |  |  | Operational Excellence | [NAME]
G&A | People |  |  |  |  | People | G&A
 |  | HR Business Partners |  |  |  | HR Business Partners | People
 |  | People Success |  |  |  | People Success | People
 |  | Talent Acquistion |  |  |  | Talent Acquistion | People
 |  | People Operations, Payments & Total Rewards |  |  |  | People Operations, Payments & Total Rewards | People
 |  | People Technology & Analytics |  |  |  | People Technology & Analytics | People
 |  | People Strategy, Planning & Compliance |  |  |  | People Strategy, Planning & Compliance | People
 | Communications |  |  |  |  | Communications | G&A
 | Knowledge |  |  |  |  | Knowledge | G&A
 | Legal |  |  |  |  | Legal | G&A
 | Legal Operations |  |  |  |  | Legal Operations | G&A
 | Business Control |  |  |  |  | Business Control | G&A
 | Procurement |  |  |  |  | Procurement | G&A
 | Mobility Strategy |  |  |  |  | Mobility Strategy | G&A
 | Corporate Development |  |  |  |  | Corporate Development | G&A
 | Finance |  |  |  |  | Finance | G&A
 |  | Accounting |  |  |  | Accounting | Finance
 |  | Fintech Compliance & Licensing |  |  |  | Fintech Compliance & Licensing | Finance
 |  | Tax & Treasury |  |  |  | Tax & Treasury | Finance
 |  | Finance Operations |  |  |  | Finance Operations | Finance
 |  | Accounts Payable |  |  |  | Accounts Payable | Finance
 |  | Account Receivable |  |  |  | Account Receivable | Finance
S&M | Marketing |  |  |  |  | Marketing | S&M
 |  | Partner Marketing |  |  |  | Partner Marketing | Marketing
 |  | Community Marketing |  |  |  | Community Marketing | Marketing
 |  | Events Marketing |  |  |  | Events Marketing | Marketing
 |  | Product Marketing |  |  |  | Product Marketing | Marketing
 |  | Lifecycle Marketing & Ops |  |  |  | Lifecycle Marketing & Ops | Marketing
 |  | Creative |  |  |  | Creative | Marketing
 | Growth |  |  |  |  | Growth | S&M
 |  | Paid Advertising |  |  |  | Paid Advertising | Growth
 |  | Content Marketing |  |  |  | Content Marketing | Growth
 |  | Regional Marketing |  |  |  | Regional Marketing | Growth
 |  | Marketing Operations |  |  |  | Marketing Operations | Growth
 | Partnerships |  |  |  |  | Partnerships | S&M
 |  | Partner Acquisition |  |  |  | Partner Acquisition | Partnerships
 |  | Partner Management |  |  |  | Partner Management | Partnerships
 |  |  | Broker Partnerships |  |  | Broker Partnerships | Partner Management
 |  | Partner Programs & Operations |  |  |  | Partner Programs & Operations | Partnerships
 | Revenue Operations & Enablement |  |  |  |  | Revenue Operations & Enablement | S&M
 |  | Sales Business Partners |  |  |  | Sales Business Partners | Revenue Operations & Enablement
 |  |  | [NAME] |  |  | [NAME] | Sales Business Partners
 |  |  | [NAME] |  |  | [NAME] | Sales Business Partners
 |  | Sales Compensation |  |  |  | Sales Compensation | Revenue Operations & Enablement
 |  | Deal Desk |  |  |  | Deal Desk | Revenue Operations & Enablement
 |  | Pricing |  |  |  | Pricing | Revenue Operations & Enablement
 | Sales - Global |  |  |  |  | Sales - Global | S&M |  |  |  | S&M - Sales | S&M - Sales
 |  | Product Line Sales |  |  |  | Product Line Sales | Sales - Global
 |  |  | Global Mobility Sales |  |  | Global Mobility Sales | Product Line Sales
 |  |  | PEO Sales |  |  | PEO Sales | Product Line Sales
 |  |  | Global Payroll Sales |  |  | Global Payroll Sales | Product Line Sales
 |  |  | HRIS Sales |  |  | HRIS Sales | Product Line Sales
 | AMER Sales |  |  |  |  | AMER Sales | S&M
 |  | NAM Sales - SMB |  |  |  | NAM Sales - SMB | AMER Sales
 |  | NAM Sales - MM |  |  |  | NAM Sales - MM | AMER Sales
 |  | GWC Sales - Scale/SMB |  |  |  | GWC Sales - Scale/SMB | AMER Sales
 |  | GWC Sales - MM/Key Acounts |  |  |  | GWC Sales - MM/Key Acounts | AMER Sales
 |  | [NAME] |  |  |  | [NAME] | AMER Sales
 | AMER Enterprise Sales |  |  |  |  | AMER Enterprise Sales | S&M
 | Sales Development |  |  |  |  | Sales Development | S&M
 |  | NAM Sales Development |  |  |  | NAM Sales Development | Sales Development
 |  | Global Mobility Sales Development |  |  |  | Global Mobility Sales Development | Sales Development
 |  | Latam Sales Development |  |  |  | Latam Sales Development | Sales Development
 |  | APAC Sales Development |  |  |  | APAC Sales Development | Sales Development
 |  | EMEA Sales Development |  |  |  | EMEA Sales Development | Sales Development
 | EMEA Sales |  |  |  |  | EMEA Sales | S&M
 |  | [NAME] |  |  |  | [NAME] | EMEA Sales
 |  | [NAME] |  |  |  | [NAME] | EMEA Sales
 |  | [NAME] |  |  |  | [NAME] | EMEA Sales
 | EMEA Enterprise Sales |  |  |  |  | EMEA Enterprise Sales | S&M
 | APAC Sales |  |  |  |  | APAC Sales | S&M
 |  | APAC Sales - SMB, MM |  |  |  | APAC Sales - SMB, MM | APAC Sales
 |  | APAC GWC Sales |  |  |  | APAC GWC Sales | APAC Sales
 | APAC Enterprise Sales |  |  |  |  | APAC Enterprise Sales | S&M
 |  | APAC Sales - ANZ |  |  |  | APAC Sales - ANZ | APAC Enterprise Sales
 |  | APAC Sales - SGP/ASEA |  |  |  | APAC Sales - SGP/ASEA | APAC Enterprise Sales
 |  | APAC Sales - India |  |  |  | APAC Sales - India | APAC Enterprise Sales
 | Sales - Strategic Accounts |  |  |  |  | Sales - Strategic Accounts | S&M
 | Sales - PYG & Partnerships |  |  |  |  | Sales - PYG & Partnerships | S&M