consolidate 2 tables into one

HI
I have 1 table, list of parts
and second table of those part and right to it list of their child
I want to consolidate the 2 tables, meaning that the result wil show part and then their child, but only the parts in the first table mention
I added a file that explain what I wsill to have
I have excel 2010 and powerpivot if it can help
the other solution might be VBA macro with loops, but I wish to avoide it
please help..

Just a small workaround which I think may be a quickest and a closest solution of what you want.

Vikas B