Here is a sample data:
Second able is what i want
Employee
| Manager
|
|---|
| 1 | a |
| 2 | a |
| 3 | b |
| 4 | b |
| a | b |
| a | b |
| b | c |
| d | c |
| f | d |
| e | f |
| x | d |
| y | f |
| z | f |
| 8 | a |
| 9 | a |
| 10 | a |
Here is what i want as result
| Employee | Manager | Dept Head |
|---|
| 1 | a | c |
| 2 | a | c |
| 3 | b | c |
| 4 | b | c |
| a | b | c |
| z | f | c |
| so on for all rows in orig table | | |