Compare and merge data given in parent child hierarchy

[vj523]

Hello Everyone, i have 2 data table in parent child hierarchy as given in attached snapshot. Now i need to create 1 table by merging both table. it should check the every child corresponding to the parent, if there are 2 child in first table and 2 child in other table for same parent then under the parent 4 child should be visible. please refer attached snapshot.

Number of row and column will vary in table and child object can be parent for other.

In case of any question, please let me know.
Your expert advise would be very helpful for me.
Thanks in Advance.

 

[vj523]

Hello Everyone, i have 2 data table in parent child hierarchy as given in attached snapshot. Now i need to create 1 table by merging both table. it should check the every child corresponding to the parent, if there are 2 child in first table and 2 child in other table for same parent then under the parent 4 child should be visible. please refer attached snapshot.

Number of row and column will vary in table and child object can be parent for other.

In case of any question, please let me know.
Your expert advise would be very helpful for me.
Thanks in Advance.

I Need the solution in Excel vba. Thanks