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 query 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 in separate fields. 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 is the data i start with but want to add data fields called Level1, Level2, Level3...etc.
Can't share data due to confidentiality.
Bookmarks