Creating an Organizational Chart Pivot

[ExcelNoob11]

I have an organizational chart that has approximately 15000 employees and is about 8 layers deep. I'm trying to associate all employees to their respective "Vice President". So far I've got a recursive vlookup but it seems unstable and messy. I've tried also creating an index table, but employees are moving often and is a mission to keep updated. My next step was going to create an index of VP's because those don't move too often and do a reverse search from there, but before I did that was wondering if there were smarter minds here who might have some knowledge to share.

The data is organized something like this:

<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; box-sizing: inherit; white-space: inherit;">[COLOR=#303336][FONT=inherit]Emp_id Manager_id
[/FONT][/COLOR][COLOR=#7D2727][FONT=inherit]1        [/FONT][/COLOR][COLOR=#7D2727][FONT=inherit]1[/FONT][/COLOR][COLOR=#303336][FONT=inherit]
[/FONT][/COLOR][COLOR=#7D2727][FONT=inherit]2        [/FONT][/COLOR][COLOR=#7D2727][FONT=inherit]1[/FONT][/COLOR][COLOR=#303336][FONT=inherit]
[/FONT][/COLOR][COLOR=#7D2727][FONT=inherit]3        [/FONT][/COLOR][COLOR=#7D2727][FONT=inherit]1[/FONT][/COLOR][COLOR=#303336][FONT=inherit]
[/FONT][/COLOR][COLOR=#7D2727][FONT=inherit]4        [/FONT][/COLOR][COLOR=#7D2727][FONT=inherit]3[/FONT][/COLOR][COLOR=#303336][FONT=inherit]
[/FONT][/COLOR][COLOR=#7D2727][FONT=inherit]5        [/FONT][/COLOR][COLOR=#7D2727][FONT=inherit]3[/FONT][/COLOR][COLOR=#303336][FONT=inherit]
[/FONT][/COLOR][COLOR=#7D2727][FONT=inherit]6        [/FONT][/COLOR][COLOR=#7D2727][FONT=inherit]5[/FONT][/COLOR][COLOR=#303336][FONT=inherit]
[/FONT][/COLOR][COLOR=#7D2727][FONT=inherit]7        [/FONT][/COLOR][COLOR=#7D2727][FONT=inherit]5[/FONT][/COLOR][COLOR=#303336][FONT=inherit]
[/FONT][/COLOR][COLOR=#7D2727][FONT=inherit]8        [/FONT][/COLOR][COLOR=#7D2727][FONT=inherit]7[/FONT][/COLOR][COLOR=#303336][FONT=inherit]
[/FONT][/COLOR][COLOR=#7D2727][FONT=inherit]9        [/FONT][/COLOR][COLOR=#7D2727][FONT=inherit]7[/FONT][/COLOR][COLOR=#303336][FONT=inherit]
[/FONT][/COLOR][COLOR=#7D2727][FONT=inherit]10       [/FONT][/COLOR][COLOR=#7D2727][FONT=inherit]7
[/FONT][/COLOR]</code>

So in the above scenario i'd like to maybe add a column that shows that employee's 4-10 are all under employee 3.

Thanks in advance!