Parent Child Relationship

[Automation Guru]

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.

[Bob Phillips]

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]

Please fine the attached file for your reference.

[Kev@Radstock]

Hi Automation Guru

Generally cross posting is frowned upon! http://www.excelforum.com/excel-form...18#post3062918

See the Excelguru Multi Forum Posting Policy: http://www.excelguru.ca/forums/faq.p...osting_details