+ Reply to Thread
Results 1 to 4 of 4

Parent Child Relationship

  1. #1
    Registered User
    Join Date
    12-26-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Parent Child Relationship

    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 Images Attached Images

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,282

    Re: Parent Child Relationship

    What good is a picture of a worksheet?
    Ben Van Johnson

  3. #3
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,914

    Re: Parent Child Relationship

    Hi Automation Guru

    Generally cross posting is frowned upon!

    http://www.excelguru.ca/forums/showt...ted=1#post6068

    Forum Rules: Rule 8
    Regards Kevin


    Merged Cells (They are the work of the devil!!!)

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Parent Child Relationship

    also posted here
    Josie

    if at first you don't succeed try doing it the way your wife told you to

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1