Hello, I need to automatically find the managers who will be responsible for each employee in a company. There are many hierarchy levels and each manager is responsible for his team of subordinates.
I have all the columns A - K and I need to fill in columns L-M-N with the names (or job title) of the people corresponding to each person, as in the following example.
I have no idea how to approach this. Data in columns A-K is from a pivot table based on the employees' database.
I have classified each person according to a hierarchy level.
For example CEO = level 1, Director = Level 2, Subdirector = level 3, managers = level 5. People in level 4, or levels 6, 7 and 8 are not responsible for any subordinates.
So, in column A I have all hierarchy levels and in columns B-K I have the hierachy level for each person.
Each SubDirector is only responsible for the people that work for him, the same goes for each manager etc.
I don't know if this makes any sense to you, but if it does, I would be really greatful for any suggestion you might have.
I'm looking forward to any thoughts or advice.
Thanks in advance!
[TABLE="width: 1249"]
<colgroup><col><col><col span="3"><col><col><col span="3"><col><col><col span="2"><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]A [/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]ALL[/TD]
[TD]LEVEL 1[/TD]
[TD]LEVEL 2[/TD]
[TD]LEVEL 3[/TD]
[TD][/TD]
[TD]LEVEL 5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]COMPANY STRUCTURE[/TD]
[TD]PEOPLE[/TD]
[TD]1ST[/TD]
[TD]2ND[/TD]
[TD]3RD[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]CEO[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]DIRECTOR 1[/TD]
[TD]JOHN[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]MARY[/TD]
[TD]DIRECTOR 1[/TD]
[TD] [/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 1[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 2[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 3[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 4[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 5[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]MANAGER 1[/TD]
[TD]HELEN[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 6[/TD]
[TD]MANAGER 1[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 7[/TD]
[TD]MANAGER 1[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 8[/TD]
[TD]MANAGER 1[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 9[/TD]
[TD]MANAGER 1[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 10[/TD]
[TD]MANAGER 1[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]7[/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 11[/TD]
[TD]MANAGER 1[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]7[/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 12[/TD]
[TD]MANAGER 1[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]8[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]8[/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 13[/TD]
[TD]MANAGER 1[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]24[/TD]
[TD]8[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]8[/TD]
[TD] [/TD]
[TD]EMPLOYEE 14[/TD]
[TD]MANAGER 1[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]MANAGER 2[/TD]
[TD]GEORGE[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]27[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 15[/TD]
[TD]MANAGER 2[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]28[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 16[/TD]
[TD]MANAGER 2[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]29[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 17[/TD]
[TD]MANAGER 2[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 18[/TD]
[TD]MANAGER 2[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]31[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]7[/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 19[/TD]
[TD]MANAGER 2[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]32[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]7[/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 20[/TD]
[TD]MANAGER 2[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]33[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]7[/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 21[/TD]
[TD]MANAGER 2[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]34[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]35[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]36[/TD]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]SUBDIRECTOR 2[/TD]
[TD]NICK[/TD]
[TD]DIRECTOR 1[/TD]
[TD] [/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]37[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]38[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]MANAGER 3[/TD]
[TD]MICHAEL[/TD]
[TD]SUBDIRECTOR 2[/TD]
[TD]DIRECTOR 1[/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]39[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 22[/TD]
[TD]MANAGER 3[/TD]
[TD]SUBDIRECTOR 2[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]40[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 23[/TD]
[TD]MANAGER 3[/TD]
[TD]SUBDIRECTOR 2[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]41[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 24[/TD]
[TD]MANAGER 3[/TD]
[TD]SUBDIRECTOR 2[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]42[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 25[/TD]
[TD]MANAGER 3[/TD]
[TD]SUBDIRECTOR 2[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]43[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]7[/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 26[/TD]
[TD]MANAGER 3[/TD]
[TD]SUBDIRECTOR 2[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]7[/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 27[/TD]
[TD]MANAGER 3[/TD]
[TD]SUBDIRECTOR 2[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]45[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]7[/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 28[/TD]
[TD]MANAGER 3[/TD]
[TD]SUBDIRECTOR 2[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]46[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]47[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]DIRECTOR 2[/TD]
[TD]JIM[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]48[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]49[/TD]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]SUBDIRECTOR 3[/TD]
[TD]JACK[/TD]
[TD]DIRECTOR 2[/TD]
[TD] [/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]50[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]51[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]MANAGER 4[/TD]
[TD]PETER[/TD]
[TD]SUBDIRECTOR 3[/TD]
[TD]DIRECTOR 2[/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]52[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 1[/TD]
[TD]MANAGER 4[/TD]
[TD]SUBDIRECTOR 3[/TD]
[TD]DIRECTOR 2[/TD]
[/TR]
[TR]
[TD]53[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 2[/TD]
[TD]MANAGER 4[/TD]
[TD]SUBDIRECTOR 3[/TD]
[TD]DIRECTOR 2[/TD]
[/TR]
[TR]
[TD]54[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 3[/TD]
[TD]MANAGER 4[/TD]
[TD]SUBDIRECTOR 3[/TD]
[TD]DIRECTOR 2[/TD]
[/TR]
[TR]
[TD]55[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 4[/TD]
[TD]MANAGER 4[/TD]
[TD]SUBDIRECTOR 3[/TD]
[TD]DIRECTOR 2[/TD]
[/TR]
[TR]
[TD]56[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 5[/TD]
[TD]MANAGER 4[/TD]
[TD]SUBDIRECTOR 3[/TD]
[TD]DIRECTOR 2[/TD]
[/TR]
[TR]
[TD]57[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]58[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]DIRECTOR 3[/TD]
[TD]JIM[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]59[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]60[/TD]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]SUBDIRECTOR 3[/TD]
[TD]NOONE[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]61[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]62[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]MANAGER 5[/TD]
[TD]PETER[/TD]
[TD]DIRECTOR 3[/TD]
[TD] [/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]63[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 1[/TD]
[TD]MANAGER 5[/TD]
[TD] [/TD]
[TD]DIRECTOR 3[/TD]
[/TR]
[TR]
[TD]64[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 2[/TD]
[TD]MANAGER 5[/TD]
[TD] [/TD]
[TD]DIRECTOR 3[/TD]
[/TR]
[TR]
[TD]65[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 3[/TD]
[TD]MANAGER 5[/TD]
[TD] [/TD]
[TD]DIRECTOR 3[/TD]
[/TR]
[TR]
[TD]66[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 4[/TD]
[TD]MANAGER 5[/TD]
[TD] [/TD]
[TD]DIRECTOR 3[/TD]
[/TR]
[TR]
[TD]67[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 5[/TD]
[TD]MANAGER 5[/TD]
[TD] [/TD]
[TD]DIRECTOR 3[/TD]
[/TR]
</tbody>[/TABLE]
I have all the columns A - K and I need to fill in columns L-M-N with the names (or job title) of the people corresponding to each person, as in the following example.
I have no idea how to approach this. Data in columns A-K is from a pivot table based on the employees' database.
I have classified each person according to a hierarchy level.
For example CEO = level 1, Director = Level 2, Subdirector = level 3, managers = level 5. People in level 4, or levels 6, 7 and 8 are not responsible for any subordinates.
So, in column A I have all hierarchy levels and in columns B-K I have the hierachy level for each person.
Each SubDirector is only responsible for the people that work for him, the same goes for each manager etc.
I don't know if this makes any sense to you, but if it does, I would be really greatful for any suggestion you might have.
I'm looking forward to any thoughts or advice.
Thanks in advance!
[TABLE="width: 1249"]
<colgroup><col><col><col span="3"><col><col><col span="3"><col><col><col span="2"><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]A [/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]ALL[/TD]
[TD]LEVEL 1[/TD]
[TD]LEVEL 2[/TD]
[TD]LEVEL 3[/TD]
[TD][/TD]
[TD]LEVEL 5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]COMPANY STRUCTURE[/TD]
[TD]PEOPLE[/TD]
[TD]1ST[/TD]
[TD]2ND[/TD]
[TD]3RD[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]CEO[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]DIRECTOR 1[/TD]
[TD]JOHN[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]MARY[/TD]
[TD]DIRECTOR 1[/TD]
[TD] [/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 1[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 2[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 3[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 4[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 5[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]MANAGER 1[/TD]
[TD]HELEN[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 6[/TD]
[TD]MANAGER 1[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 7[/TD]
[TD]MANAGER 1[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 8[/TD]
[TD]MANAGER 1[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 9[/TD]
[TD]MANAGER 1[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 10[/TD]
[TD]MANAGER 1[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]7[/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 11[/TD]
[TD]MANAGER 1[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]7[/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 12[/TD]
[TD]MANAGER 1[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]8[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]8[/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 13[/TD]
[TD]MANAGER 1[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]24[/TD]
[TD]8[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]8[/TD]
[TD] [/TD]
[TD]EMPLOYEE 14[/TD]
[TD]MANAGER 1[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]MANAGER 2[/TD]
[TD]GEORGE[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]27[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 15[/TD]
[TD]MANAGER 2[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]28[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 16[/TD]
[TD]MANAGER 2[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]29[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 17[/TD]
[TD]MANAGER 2[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 18[/TD]
[TD]MANAGER 2[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]31[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]7[/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 19[/TD]
[TD]MANAGER 2[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]32[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]7[/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 20[/TD]
[TD]MANAGER 2[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]33[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]7[/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 21[/TD]
[TD]MANAGER 2[/TD]
[TD]SUBDIRECTOR 1[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]34[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]35[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]36[/TD]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]SUBDIRECTOR 2[/TD]
[TD]NICK[/TD]
[TD]DIRECTOR 1[/TD]
[TD] [/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]37[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]38[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]MANAGER 3[/TD]
[TD]MICHAEL[/TD]
[TD]SUBDIRECTOR 2[/TD]
[TD]DIRECTOR 1[/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]39[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 22[/TD]
[TD]MANAGER 3[/TD]
[TD]SUBDIRECTOR 2[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]40[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 23[/TD]
[TD]MANAGER 3[/TD]
[TD]SUBDIRECTOR 2[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]41[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 24[/TD]
[TD]MANAGER 3[/TD]
[TD]SUBDIRECTOR 2[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]42[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 25[/TD]
[TD]MANAGER 3[/TD]
[TD]SUBDIRECTOR 2[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]43[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]7[/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 26[/TD]
[TD]MANAGER 3[/TD]
[TD]SUBDIRECTOR 2[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]44[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]7[/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 27[/TD]
[TD]MANAGER 3[/TD]
[TD]SUBDIRECTOR 2[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]45[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]7[/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 28[/TD]
[TD]MANAGER 3[/TD]
[TD]SUBDIRECTOR 2[/TD]
[TD]DIRECTOR 1[/TD]
[/TR]
[TR]
[TD]46[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]47[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]DIRECTOR 2[/TD]
[TD]JIM[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]48[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]49[/TD]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]SUBDIRECTOR 3[/TD]
[TD]JACK[/TD]
[TD]DIRECTOR 2[/TD]
[TD] [/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]50[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]51[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]MANAGER 4[/TD]
[TD]PETER[/TD]
[TD]SUBDIRECTOR 3[/TD]
[TD]DIRECTOR 2[/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]52[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 1[/TD]
[TD]MANAGER 4[/TD]
[TD]SUBDIRECTOR 3[/TD]
[TD]DIRECTOR 2[/TD]
[/TR]
[TR]
[TD]53[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 2[/TD]
[TD]MANAGER 4[/TD]
[TD]SUBDIRECTOR 3[/TD]
[TD]DIRECTOR 2[/TD]
[/TR]
[TR]
[TD]54[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 3[/TD]
[TD]MANAGER 4[/TD]
[TD]SUBDIRECTOR 3[/TD]
[TD]DIRECTOR 2[/TD]
[/TR]
[TR]
[TD]55[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 4[/TD]
[TD]MANAGER 4[/TD]
[TD]SUBDIRECTOR 3[/TD]
[TD]DIRECTOR 2[/TD]
[/TR]
[TR]
[TD]56[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 5[/TD]
[TD]MANAGER 4[/TD]
[TD]SUBDIRECTOR 3[/TD]
[TD]DIRECTOR 2[/TD]
[/TR]
[TR]
[TD]57[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]58[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]DIRECTOR 3[/TD]
[TD]JIM[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]59[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]60[/TD]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]SUBDIRECTOR 3[/TD]
[TD]NOONE[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]61[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]62[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]MANAGER 5[/TD]
[TD]PETER[/TD]
[TD]DIRECTOR 3[/TD]
[TD] [/TD]
[TD]CEO[/TD]
[/TR]
[TR]
[TD]63[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 1[/TD]
[TD]MANAGER 5[/TD]
[TD] [/TD]
[TD]DIRECTOR 3[/TD]
[/TR]
[TR]
[TD]64[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 2[/TD]
[TD]MANAGER 5[/TD]
[TD] [/TD]
[TD]DIRECTOR 3[/TD]
[/TR]
[TR]
[TD]65[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 3[/TD]
[TD]MANAGER 5[/TD]
[TD] [/TD]
[TD]DIRECTOR 3[/TD]
[/TR]
[TR]
[TD]66[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 4[/TD]
[TD]MANAGER 5[/TD]
[TD] [/TD]
[TD]DIRECTOR 3[/TD]
[/TR]
[TR]
[TD]67[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EMPLOYEE[/TD]
[TD]EMPLOYEE 5[/TD]
[TD]MANAGER 5[/TD]
[TD] [/TD]
[TD]DIRECTOR 3[/TD]
[/TR]
</tbody>[/TABLE]