Post an example workbook with the input data in it. i for one am not going to spend time creating data you already have.
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.
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.
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
Bookmarks