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

Tier 1 | Tier 1 Owner | [NAME] | Tier 2 Owner | Tier 3 | Tier 3 Owner | [NAME] | Tier 4 Owner | Tier 5 | Tier 5 Owner | Tier 6 | Tier 6 Owner
R&D | Alex, Yaron | Engineering | Yaron | Software Development | Yaron | Payroll Engineering
 |  |  |  |  |  |  |  | US Payroll
 |  |  |  |  |  |  |  | PEO Engineering
 |  |  |  |  |  |  |  | Global Payroll Engineering
 |  |  |  |  |  |  |  | Payroll Core
 |  |  |  |  |  |  |  | EOR Engineering
 |  |  |  |  |  |  |  | Payroll Engines
 |  |  |  |  |  |  |  |  |  | Payspace
 |  |  |  |  |  |  |  | Contracts & ICs
 |  |  |  |  |  |  |  | Benefits
 |  |  |  |  |  | Mobility Engineering
 |  |  |  |  |  | Time & Attendance
 |  |  |  |  |  | HRIS Engineering
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Platform
 |  |  |  |  |  |  |  | Integrations
 |  |  |  |  |  |  |  | Onboarding
 |  |  |  |  |  | Finance & Payments
 |  |  |  |  |  | Knowledge & Growth
 |  |  |  |  |  | UI
 |  |  |  |  |  | Tech Excellence
 |  |  |  | Infra | [NAME] | Infra Engineering | [NAME]
 |  |  |  |  |  | DevOps | [NAME]
 |  |  |  |  |  | Database | Mor Lehr
 |  |  |  | IT | [NAME]
 |  |  |  | InfoSec | [NAME]
 |  | Product | [NAME]
 |  |  |  | Product Management | [NAME] | Product, EOR & Payroll | [NAME]
 |  |  |  |  |  | Product, HRIS | Pearce Dolan
 |  |  |  |  |  | Product, Engage | Mehmet [NAME]
 |  |  |  |  |  | Product, Payments & Integrations | [NAME]
 |  |  |  |  |  |  |  | Product Partnerships
 |  |  |  | Data | [NAME] | Data Science | [NAME]
 |  |  |  |  |  | Data & Analytics | [NAME]
 |  |  |  |  |  | Product Analytics | [NAME]
 |  |  |  |  |  | Platform Operations | [NAME]
 |  |  |  |  |  | Integrations | [NAME]
 | [NAME] | Customer Support & Services | [NAME] | Tech Ops & FinTech Support | TBD | FinTech Support | Priyanka Adhikari
 |  |  |  |  |  | Tech Support | Efosa Emuze
[NAME] |  |  |  | Customer Operations | [NAME] | - Reviews and Complaints - Client Pod - Country Pod  - Core Pod
 |  |  |  | Customer Enablement | Folio Laurent Pierre | - Customer Support Training - Customer Support QA
 |  | Customer Success | [NAME] | Customer Success | [NAME] | Customer Success, Scale
 |  |  |  |  |  | Customer Success, Enterprise
 |  |  |  |  |  | [NAME], EMEA
 |  |  |  |  |  | Customer Success, APAC
 |  |  |  |  |  | [NAME], AMER
 |  | Operations | [NAME] | Expansion Operations | [NAME] | - Strategy - Business Operations - GTM Processes & Systems  - GTM Enablement
 |  |  |  | Customer Operations | [NAME]
 |  |  |  |  |  | Global Payroll | TBH
 |  |  |  |  |  |  |  | Payroll Operations
 |  |  |  |  |  | Tech Ops | [NAME] | Payroll Implementation
 |  |  |  |  |  | FinTech Operations | Tural Nagiev
 |  |  |  |  |  | HR Experience & Mobility | Tantawy | HR Experience
 |  |  |  |  |  |  |  | Mobility
 |  |  |  |  |  | Global Service Center | Andrii Osipov
 |  |  |  |  |  | Payroll Implementation | [NAME]
 |  |  |  |  |  | PEO Operations | [NAME]
 |  |  |  | Customer Onboarding | [NAME]
 |  |  |  | Operational Excellence | [NAME]
G&A |  | People |  | HR Business Partners | [NAME] | HRBP, R&D | [NAME]
 |  |  |  |  |  | HRBP, S&M | [NAME]
 |  |  |  |  |  | HRBP, G&A | [NAME]
 |  |  |  |  |  | HRBP, COGS | [NAME]
 |  |  |  | People Success | [NAME]
 |  |  |  | Talent Acquistion | [NAME]
 |  |  |  |  |  | Talent Acquisition Operations | [NAME]
 |  |  |  |  |  | Talent Acquisition Management | [NAME]
 |  |  |  | People Operations, Payments & Total Rewards | Mariah Hantis
 |  |  |  |  |  | People Operations | Mariah Hantis
 |  |  |  |  |  | Payments and Payroll | Pablo Berberana
 |  |  |  |  |  | Total Rewards | [NAME]
 |  |  |  | People Technology & Analytics | [NAME]
 |  |  |  |  |  | People Technology | [NAME]
 |  |  |  |  |  | People Analytics | [NAME]
 |  | Communications | [NAME] | Corporate Communications | [NAME]
 |  |  |  | Social Media | [NAME]
 |  |  |  | Brand Communications | [NAME]
 |  | Knowledge | [NAME] | Content | [NAME] | Technical Content | [NAME]
 |  | Legal | [NAME] | Legal Counsel | [NAME]
 |  |  |  | Legal Operations | [NAME]
 |  | Procurement | [NAME] | Procurement Management | [NAME]
 |  | Global Corporate Services | [NAME]
 |  | Corporate Development & Strategic Partnerships | [NAME] | Corporate Development | Franck Neron Bancel
 |  |  |  | Strategic Partnerships | [NAME]
 |  | Finance | [NAME] | Business Analysis and Control | [NAME]
 |  |  |  | Accounting | [NAME]
 |  |  |  |  |  | Accounts Payable
 |  |  |  |  |  | Account Receivable
 |  |  |  | Fintech Compliance & Licensing
 |  |  |  | Tax & Treasury | [NAME]
 |  |  |  | Finance Operations | [NAME]
 |  | Policy | [NAME]
 |  | Compliance | [NAME]
 |  | Broker Services | [NAME] | Broker Services Management | [NAME]
S&M | Shuo, [NAME] | Marketing | [NAME], [NAME]
 |  |  |  | Customer Marketing | [NAME] | Partner Marketing | [NAME]
 |  |  |  |  |  | Community Marketing | ?
 |  |  |  |  |  | Events Marketing | [NAME]
 |  |  |  |  |  | Product Marketing | Grace Stuart
 |  |  |  |  |  | Lifecycle Marketing & Operations | [NAME]
 |  |  |  |  |  | Creative | Jola Aerts
 |  |  |  | Growth Marketing | [NAME]
 |  |  |  |  |  | Paid Advertising | [NAME]
 |  |  |  |  |  | Content Marketing | Anja Simic
 |  |  |  |  |  | Expansion Marketing | [NAME]
 |  | Partnerships | [NAME]
 |  |  |  | Partner Strategy and Operations | [NAME]
 |  |  |  | Partner Management | [NAME]
 |  | Revenue Operations | Shuo | Revenue Operations | [NAME]
 |  |  |  |  |  | Sales Business Partners
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Sales Compensation
 |  |  |  |  |  | Deal Desk
 |  |  |  |  |  | Pricing
 |  | Sales - Global | Shuo | Enterprise Sales
 |  |  |  | Sales, America |  | Product Line Sales
 |  |  |  | Sales, APAC |  |  |  | Global Mobility Sales
 |  |  |  | Sales, EMEA |  |  |  | PEO Sales
 |  |  |  |  |  |  |  | Global Payroll Sales
 |  |  |  |  |  |  |  | HRIS Sales
 |  |  |  |  |  | AMER Sales
 |  |  |  |  |  |  |  | NAM Sales - SMB
 |  |  |  |  |  |  |  | NAM Sales - MM
 |  |  |  |  |  |  |  | GWC Sales - Scale/SMB
 |  |  |  |  |  |  |  | GWC Sales - MM/Key Acounts
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | AMER Enterprise Sales
 |  |  |  |  |  | Sales Development
 |  |  |  |  |  |  |  | NAM Sales Development
 |  |  |  |  |  |  |  | Global Mobility Sales Development
 |  |  |  |  |  |  |  | Latam Sales Development
 |  |  |  |  |  |  |  | APAC Sales Development
 |  |  |  |  |  |  |  | EMEA Sales Development
 |  |  |  |  |  | EMEA Sales
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  | EMEA Enterprise Sales
 |  |  |  |  |  | APAC Sales
 |  |  |  |  |  |  |  | APAC Sales - SMB, MM
 |  |  |  |  |  |  |  | APAC GWC Sales
 |  |  |  |  |  | APAC Enterprise Sales
 |  |  |  |  |  |  |  | APAC Sales - ANZ
 |  |  |  |  |  |  |  | APAC Sales - SGP/ASEA
 |  |  |  |  |  |  |  | APAC Sales - India
 |  |  |  |  |  | Sales - Strategic Accounts
 |  |  |  |  |  | Sales - PYG & Partnerships