So, you are saying that you have 3 columns like this:

[Name] [Supervisor] [Job Desc]
John Sam Worker
Helen Tom Worker
Tom Paul Manager
Sam Mary Manager
Mary Phil Director
Phil Joe Sr Director
Joe Vice P
Phil Joe Sr Director
Paul Carol Director
Carol Jon Sr Director
Jon Vice P

and you want to transpose these columns into your hierarchies?

What are the different categories of Job Descrion that you can have?
Are all the names unique?

Pete

On Feb 11, 6:01*pm, Pepper wrote:
Thanks for the feedback Sean but if it was that simple, I would not need help.
I need to show the reporting hierarchy of each employee regardless of their
job title

*[Name] *[Manager] *[Director] * [Senior Director] *[Vice President]
*John * * * *Sam * * * * * *Mary * * * * * Phil * * * * * * * * * * Joe
*Helen * * * Tom * * * * * *Paul * * * * * *Carol * * * * * * * * *Jon
*Sam * * * * * * * * * * * * * Mary * * * * * Phil * * * * * * * * * * Joe
Mary * * * * * * * * * * * * * * * * * * * * * * *Phil * * * * * * * * * * Joe

Sam is both the manager of John and an Employee (in the name field)
reporting to Mary who is a Director.
Mary (the employee/director) reports to Phil.



"Sean Timmons" wrote:
Are you looking to just show the rows with employees only? If so, simply sort
by manager and select nonblanks.

"Pepper" wrote:

I have spread sheet from a mainframe download listing several thousand *
employees of my company.
I have three fields, [Employee Name] *[Manager] *[Job Description] that are
of interest. *The Job Description applies to the Employee not the manager,
but the manager(s) is also an employee and appears in the Employee Name field.
Job Desriptions are like, Manager of ......, Dir of......., Sr Dir of......
where the ....is "fill in the blank.

*I need to come up with a way to display the reporting order of each employee:
[Name] *[Manager] *[Director] * [Senior Director] *[Vice President]
John * * * *Sam * * * * * *Mary * * * * * Phil * * * * * * * * * * Joe
Helen * * * Tom * * * * * *Paul * * * * * *Carol * * * * * * * * *Jon
Sam * * * * * * * * * * * * * Mary * * * * * Phil * * * * * * * * * * Joe

Note that John reports to Sam, Sam reports to Mary and to display his
reporting order, he will be in the Name field, not Manager field, since he is
an employee as well as a manager

Suggestions on how get this done is desparately needed.

Thanks in advance
Pepper- Hide quoted text -

- Show quoted text -