From Multilevel BOM to Flat BOM

Hi all,

it has been days I am struggling to find a solution to this, but I was not able to do that.

Basically, I am starting from a multilevel BOM and I need to build the flat BOM. I was thinking to make it with the Power Pivot Chart, for which I build the relationship between the BOM, the first level (Sub Assembly) and Components.

What I am looking for is a chart with the name of the father in the first column, and the other columns with all the components needed to build the father.

I could also attach the file, but I don't know how to do that.

Could Anyone support me?

Thanks