Parent Child Relationship

Automation Guru

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

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
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.
 

Automation Guru

New member
Joined
Dec 25, 2011
Messages
3
Reaction score
0
Points
0
Age
37
Location
India
Please fine the attached file for your reference.
 

Attachments

  • PZC-Try1.xlsx
    12.4 KB · Views: 161
Top