Create Org Chart Mgmt Levels from flat file

stephe3333

New Member
I have a listing of 500 employees with one data field that gives the next reporting manager by name but not employee number. Ultimately there are up to six levels of management to get to the Regional manager. What formulas or structure could I use to create a management hierarchy which will identify the Regional Mgr as Level 1 and all subsequent managers perhaps down to level 6 for every single employee. Some intermediate management will obviously only have a few names and not all the way down to Level 6.

Example below is what i would like where only the first three columns plus last field for immediate reporting mgr.

Emp#Emp_NameJob_TitleLeve1_MgrLevel2_MgrLevel3_MgrLevel4_MgrLevel5_MgrLevel6_MgrReporting_Mgr
aaa123456Smith, JohnReg Mgr
aac999999Jones, BobWorkerSmith, JohnJordan, MichaelManning, PeytonJulio, JonesRoy, PatrickHarper, BryceHarper, Bryce
aab555555Jackson, BoSuperSmith, JohnJordan, MichaelManning, PeytonManning, Peyton

<tbody>
</tbody>
 

Some videos you may like

This Week's Hot Topics

Top