Create Org Chart Mgmt Levels from flat file

[stephe3333]

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_Name	Job_Title	Leve1_Mgr	Level2_Mgr	Level3_Mgr	Level4_Mgr	Level5_Mgr	Level6_Mgr	Reporting_Mgr
aaa123456	Smith, John	Reg Mgr
aac999999	Jones, Bob	Worker	Smith, John	Jordan, Michael	Manning, Peyton	Julio, Jones	Roy, Patrick	Harper, Bryce	Harper, Bryce
aab555555	Jackson, Bo	Super	Smith, John	Jordan, Michael	Manning, Peyton				Manning, Peyton

<tbody>
</tbody>