masai_chadi
New Member
- Joined
- Sep 29, 2006
- Messages
- 5
I have a list of over 10,000 employee with 7 levels of employee- supervisor relationship from our HR system. The list looks like:
Joe reports to Mary
Sandar reports to Mary
Peter reports to Philip
Viola reports to Mary
Mary reports to David
Saly reports to Mary
Philip reports to David
Parent and Children are stored in different columns (say columns A & B).
I would like to produce a tree view, in another tab, that looks like:
David (column A)
--Mary (column B)
----Joe (column C)
----Sandra (column C)
----Saly (column C)
----Viola (column C)
--Philip (column B)
----Peter (column C)
How can I achieve this?
Joe reports to Mary
Sandar reports to Mary
Peter reports to Philip
Viola reports to Mary
Mary reports to David
Saly reports to Mary
Philip reports to David
Parent and Children are stored in different columns (say columns A & B).
I would like to produce a tree view, in another tab, that looks like:
David (column A)
--Mary (column B)
----Joe (column C)
----Sandra (column C)
----Saly (column C)
----Viola (column C)
--Philip (column B)
----Peter (column C)
How can I achieve this?