Bill of Materials conversion from multi level to single level

Book1.xlsx

Dear Experts,

I am herewith attaching a file that contains the problem.
I have multi level BOM available as a input & I want it to convert into single level.

Please help me...

Personally I think I would go with a VBA solution for this one.
Is that an option?

Originally Posted by zumbalj

I don't understand what you're trying to do. Are you adding values to get this output?

Thanks for your reply...
I am receiveing this input from our CAD data & I want to upload this data in ERP but the ERP needs this data in single level.
Hence I want to modify the available input in prescribed output format...

Moreover I don't know VBA, I know only excel...

Thanks...

Thanks for your reply...

I don't know VBA, I know only excel...

Thanks...

Yeah but if they gave you a VBA solution would that work?

Book1.xlsxI would highlight the cells under the data, and go to Go To(f5)-> Special(Alt+S)-> Blanks(K) then hit =(up one cell) Enter so it repeats values.

Then the formulas I have on the right work fine for what you are trying to do.

Originally Posted by mikeTRON

Attachment 248797I would highlight the cells under the data, and go to Go To(f5)-> Special(Alt+S)-> Blanks(K) then hit =(up one cell) Enter so it repeats values.

Then the formulas I have on the right work fine for what you are trying to do.

Thank you very much for sparing your time for my problem....
Aboe given formula works for the sheet i have uploaded earlier.
But there are few cases where this formula is not working.
I have uploaded a case where it won't work.

Moreover i am facing trouble in copying the up one cell data. Upto identifying blanks in entire database is OK but after that what i have to do? Can you elaborate in detailed steps???

Book3.xlsx

Originally Posted by mikeTRON

Attachment 248797I would highlight the cells under the data, and go to Go To(f5)-> Special(Alt+S)-> Blanks(K) then hit =(up one cell) Enter so it repeats values.

Then the formulas I have on the right work fine for what you are trying to do.

Thank you very much for sparing your time for my problem....
Aboe given formula works for the sheet i have uploaded earlier.
But there are few cases where this formula is not working.
I have uploaded a case where it won't work.

Moreover i am facing trouble in copying the up one cell data. Upto identifying blanks in entire database is OK but after that what i have to do? Can you elaborate in detailed steps???

Hello mikeTRON

Can you help me?

With thanks.....