List of all Direct and Indirect Reports by Supervisor ID

[kamccar]

Hi! I am really hoping someone can help me. I have a list of about 3,000 employees, with one supervisor ID tied to each employee ID. I need a list next to each supervisor ID that gives me all of their direct reports and their indirect reports. I wanted these ID's to populate in separate columns next to each supervisor ID, since each supervisor will have a different amount of direct/indirect reports. I'm not sure if I would need to use a VBA script for this, but any help would be so greatly appreciated.

Thank you!

 

[Peter_SSs]

If you made up small set of dummy sample data and the expected results and explained again by referring to that sample, your question may become a lot clearer to your potential helpers.
My signature block below has help regarding posting sample data.