Split hierarchy childs into individual columns

[Emilycr]

Hi there,
I have got an Excel issue I thought it would be easier than it actually is (for me anyway!)
There are 2 columns: Employee ID and Supervisor ID.

The idea is to create a file in which the hierarchy is displayed in multiple columns with lest say CEO Employee ID in column A, then Execs - Direct reports to the CEO in column B, then direct reports to Exec members in column C and so on.

I have tried PowerPivot to create a hierarchy but the resulting hierarchy only provides Supervisor ID in one column and their Direct Reports on another one, not the full hierarchy. Is there a way to solve this?

Regards

 

[earthworm]

can you give a sample data

 

[Emilycr]

Employee Number = 7618949 reports into 1060419. Employee Id = 1060419 reports into 7360925. What I would like to see is Employee Id = 7360925 in column A, followed by Employee ID = 1060419 in Column B and Employee ID = 7618949 in column C

Employee Number	Supervisor Work Number
1060419​	7360925​
7618949​	1060419​