count of Supervisor & count of their direct reports

Hi, I hope you can help.

This is what I need to do. I have a list of 1,300 employees each attached to a supervisor. I know to get the count of employees for each supervisor, but now I need to know if the supervisor has a direct report(s) how many employees report to that person(s). Is this something I can easily create?

Supervisor A
Employee I
Employee II
Employee III (Supervisor B)
Employee IV
Employee V

I need to have the results in two separate columns, ie: Supervisor A = 3 direct reports, Supervisor Direct Reports Reports = 2 (may be more than 2 columns depending on how deep in the organization)

Does this make sense?

Please let me know of any questions and as always I APPRECIATE you and this forum.

Regards,

My indentations did not take in the above:

Employees I - III report to Supervisor A, Employees IV and V report to Supervisor B, which is Employee III

It would help if you attached a sample Excel workbook, then we can see exactly how your data is laid out. Make sure you de-sensitize it first.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Hope this helps.

Pete

Thank you!