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:	82 
Size:	27.8 KB 
ID:	1005   Click image for larger version. 

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

  2. #2
    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
  •