July 21, 2021
January 31, 2022
With a 2-level BOM it's relatively easy. With your set-up it takes a merge, a few consecutive steps of combining columns and cleaning up. Quite easy to follow. If your real situation has more levels it becomes more complicated.
In the attached file I've added a PQ solution for you to consider.