Filter a list (only one column) with two diferent column value automat

Good morning!
I bother you for a situation that I need to solve, I looked for different topics on the portal, but I didn't find anything similar.-

I have a material structure, where each line is a component of the main structure, and in turn there are also the semi-finished products up to the component level according to the example.
In this same table there are many different products and I need to filter the main one so that all the related ones are filtered.-

example.xlsx

Attached is an example of the original table and the expected filtered result.-
Is there a formula or method to do this?

Thank you very much!!!

Good Afternoon!



I'm using excel 2016, sorry.-

The relationship is between the code columns.

For example, the code 10000 is related to the codes 1001, 1002 and 1003.

Code 1001 is related to codes 101 and 102

The 101, with the 10 and 11

I hope I have been able to clarify.-

Thank you very much for your help!!!

I will try that way