Results 1 to 4 of 4

Thread: Parent Child Relationship

  1. #1
    Neophyte Automation Guru's Avatar
    Join Date
    Dec 2011
    Location
    India
    Posts
    3
    Articles
    0

    Parent Child Relationship



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I need an assistance to understand how to do support the following.

    In server we have two levels of hierarchy of data viz.
    Parent: All – Plant Line
    Children: Group – Plant Line

    I get the data in attached (Input Data.jpg) format from the server –
    Initially, all the Parent data i.e., All – Plant Line
    followed by, all Children data of all those Parents i.e., Groups – Plant Line

    I need to arrange them, through formula probably using some Array etc., in Tree format i.e.,
    Parent1
    Child1
    Child2

    Parent2
    Child2
    Child5

    Parent3
    Child1
    Child4


    Attached (Required Output.jpg) is the example –

    Here, I could get this by simply performing 2-level sorting on column-2 and then on column-1.
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Required Output.jpg 
Views:	111 
Size:	27.8 KB 
ID:	1005   Click image for larger version. 

Name:	Input Data.jpg 
Views:	67 
Size:	27.6 KB 
ID:	1006  

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,846
    Articles
    0
    Excel Version
    O365
    Post an example workbook with the input data in it. i for one am not going to spend time creating data you already have.

  3. #3
    Neophyte Automation Guru's Avatar
    Join Date
    Dec 2011
    Location
    India
    Posts
    3
    Articles
    0
    Please fine the attached file for your reference.
    Attached Files Attached Files

  4. #4

Posting Permissions

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