Showing organizational reporting relationships in a table

[Brunswick]

Hallo,
I work In HR and I need to create and view reporting relationships in a table. The the table I am looking to produce would look something like this: The numbers represent position numbers and the levels are supervisory levels.

Level 1	Level 2	Level 3	Level 4	Level 5	Level 6	Level 7	Level 8	Level 9	Position Title
	00096267								Senior Manager
		00096269							Manager 1
		00096277							Manager 2
			00096319						Supervisor 1
			00096325						Supervisor 2
				00096296					Employee 1
				00096404					Employee 2
			00096329						Supervisor 3
			00096330						Supervisor 4
			00096343						Supervisor 5
			00143555						Supervisor 6
		00096291							Manager 3
		00096323							Manager 4
		00096323							Manager 5

The table that was provided to me has position numbers and their corresponding supervisor position numbers as below:

Position Number	Supervisor position number
0000077455	0000087183
0000077456	0000087458
0000077467	0000087183
0000077468	0000087183
0000077483	0000101819
0000077486	0000089540

Any help would be great as the table I am working with has about 10k rows. Positions ranging from the CEO to front line workers.

 

[CA Vijay Gupta]

Hi Brunswick,

What does the Level denotes here?

You want position number with there respective Supervisory position?

 

[Brunswick]

Hi Brunswick,

What does the Level denotes here?

You want position number with there respective Supervisory position?

Hallo CA,
The level denotes the supervisory level; where level 1 would be the CEO, level 2 Vice Presidents, Level 3 Department Directors, etc.

Hopefully this makes sense.

 

[CA Vijay Gupta]

Hi Brunwick,

If I take the below Sample Data:

Position Title	Position Number	Supervisor position number	Level
Senior Manager	77455​	87183​	Level 1
Manager 1	77456​	87458​	Level 2
Manager 2	77467​	87183​	Level 1
Supervisor 1	77468​	87183​	Level 1
Supervisor 2	77483​	101819​	Level 3
Employee 1	77486​	89540​	Level 4

This is My Outcome;

	Level 1	Level 2	Level 3	Level 4
Position Title/ Supervisory Position Number	87183​	87458​	101819​	89540​
Employee 1				77486​
Manager 1		77456​
Manager 2	77467​
Senior Manager	77455​
Supervisor 1	77468​
Supervisor 2			77483​
Grand Total	232390​	77456​	77483​	77486​

Just Check, if this is what you are looking for??

 

[Brunswick]

Hi Brunwick,

If I take the below Sample Data:

Position Title	Position Number	Supervisor position number	Level
Senior Manager	77455​	87183​	Level 1
Manager 1	77456​	87458​	Level 2
Manager 2	77467​	87183​	Level 1
Supervisor 1	77468​	87183​	Level 1
Supervisor 2	77483​	101819​	Level 3
Employee 1	77486​	89540​	Level 4

This is My Outcome;

	Level 1	Level 2	Level 3	Level 4
Position Title/ Supervisory Position Number	87183​	87458​	101819​	89540​
Employee 1				77486​
Manager 1		77456​
Manager 2	77467​
Senior Manager	77455​
Supervisor 1	77468​
Supervisor 2			77483​
Grand Total	232390​	77456​	77483​	77486​

Just Check, if this is what you are looking for??

Thanks for responding,
This is on the right track but not quiet what I am looking for. I am looking for a table that will clearly show reporting relationships. For instance Manager 1 who occupies position number 77456 reports to Senior Manager who occupies position number 77455, etc. You can remove the levels and just have position numbers as blow: i..e. each level supervises the level below it. in the table below position number 96269 and 96277 report to position number 96267.

Level 1	Level 2	Level 3	Level 4	Level 5	Level 6	Level 7	Level 8	Level 9
Position #	Position #	Position #	Position #	Position #	Position #	Position #	Position #	Position #
	96267​
		96269​
		96277​
			96319​
			96325​
				96296​
				96404​