please help in vba macro--Compare and merge data given in parent child hierarchy

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.
i am looking for a solution in excel vba.
In case of any question, please let me know.
Your expert advise would be very helpful for me.
Thanks in Advance.

Thank you for the pictures.
Just what I was looking for.