Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Aug 2012
    Location
    India
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Need to create a simple Hierarchy

    Hi All,

    I have received a data of the employee and their reporting relationship. However the extract is column by column. Is there a way to build the hierarchy using the attached excel file. I need to build this to see if the employees are rolling up to the top correctly.

    All I have included in the employee number.

    Looking forward to a simple solution.

    Regards
    Nethra
    Attached Files Attached Files

  2. #2
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    990
    Thanks
    56
    Thanked 105 Times in 90 Posts
    Please can you explain what the data is, how you want to use it, and what the output should look like.

    I can GUESS from test.xlsx but am not sure.

  3. #3
    New Lounger
    Join Date
    Aug 2012
    Location
    India
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi

    This is the organisation relationship. starting top down... so the column b will have the emp id of the top most executive and the goes further down. I need to build a simple organisation chart

    Hope this clarifies.

    Regards

  4. #4
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    990
    Thanks
    56
    Thanked 105 Times in 90 Posts
    Nearly !

    Can you post an example of how you want the output to look - based perhaps on the first few lines of the test.xlsx ?

  5. #5
    New Lounger
    Join Date
    Aug 2012
    Location
    India
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Martin,

    Apologies to not have responded earlier. It was an urgent requirement, so managed to do it manually.

    Regards
    Nethra

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •