Parent Child Relationship

Automation Guru

Automation Guru

New member
Joined
Dec 25, 2011
Messages
3
Reaction score
0
Points
0
Age
39
Location
India
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.
 

Attachments

  • Required Output.jpg
    Required Output.jpg
    27.8 KB · Views: 119
  • Input Data.jpg
    Input Data.jpg
    27.6 KB · Views: 77
Post an example workbook with the input data in it. i for one am not going to spend time creating data you already have.
 
Please fine the attached file for your reference.
 

Attachments

  • PZC-Try1.xlsx
    12.4 KB · Views: 161
You must log in or register to reply here.
Back
Top