Brunswick
New Member
- Joined
- Jun 22, 2020
- Messages
- 3
- Office Version
- 2013
- 2010
- Platform
- Windows
- Mobile
- Web
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.
The table that was provided to me has position numbers and their corresponding supervisor position numbers as below:
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.
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.