I'm trying to create a multilevel/indented bom from a flat bom. The flat bom would look similar to the attached with the output indented bom also on the attached. My first thought is to search the assembly part number in the columns and output the rows in which they appear.

Thanks in advance for you helpBOM TEST.xlsx