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.
Bookmarks