Looking for a macro/VBA that can data group rang of lines based on cells contents

[Zadok]

Hi Guys,

We are managing Bill-of-Materials (BOM) list in hierarchal order.
I'm looking for a macro/VBA that can data group rang of lines based on cells contents,
final result can be nesting of groups within group, I attached an example file.

Thanks,
Zadok

[watersev]

hi Zadok, basing on the posted example it could be done this way

[Zadok]

Hi watersev,

Thank you for helping, the macro you suggest indeed return with the results as i asked for.

Problem is that in actual BOMs, the nesting level is up to 5 (sorry for not mention this in 1st example file),
I tried to use macro w/ 5 levels BOM, but the macro not group 5 hierarchical levels (as attached example file).
Please see the "results" worksheet in the attached file, this represent the actual data grouping required for 5 levels.
If possible to re-adjust the macro it will realy great!

Best Regards,
Zadok

[watersev]

it's a bit different result from yours but I hope it will suit you needs

[Zadok]

Hi Watersave,

Thank you my friend, it's works like a magic
Hope i'll know to write such code someday.

Thanks,
Zadok

[sdround]

Sample data.xlsx

I have a similar problem. I need to group data by "SCN" number. Each SCN number is an order that may have multiple FSC (finish stock numbers) associated with it. Need to build a macro so that i can group the FSC's with one SCN. Also, need to subtotal each of the column headers.