Multi level bill of materials

[22strider]

Hello Friends

I need to seperate multi-level bills of materials in seperate spreadsheet. So that I can have one level of bill of materials of one assembly on one spreadsheet and next level of the same assembly on next spreadsheet. Once all levels of one assembly are put on different spreadsheets then go to the next assembly and do the same thing.
I have all the data in single spreadsheet. Following are the columns that I have in my spreadsheet:
1) Parent Part Number (Text);
2) Level of bill of materials (numeric); levels are the numbers starting from 0 to 10
3) Child part number (text);
4) Quantity (numeric)
Background: Actually this is a data extract that I got from an application. And now I need to import this to another application but the import tool require data from Single level of bill of materials from One assembly at a time.

Any help will be appreciated. Without a macro I will be down to doing cut a paste on couople thousand rows.

Thanks
Rajesh

 

[Smitty]

Welcome to the Board!

It'll be tough to do without seeing a sample of your data (see How to display your sheet on the board/HTML Maker FAQ).

In the meantime you might want to look at Data-->Filter to start creating separate levels.

 

[6ktchamp]

I have Input data as in LEFT side (Single Level BOM data) and want to convert it to Multi-Level BOM data.
Level 0 is for Top Part Number in the BOM. Below example has two BOM with Top Part number as A and X. Please advise if we can use Macro /R / Python to solve this.

Input Data						Output Data
Component	Parent	Quantity				Component	Parent	Top Part Number in BOM	Quantity	Level
B	A	10				A	A	A	0	0
C	A	10				B	A	A	10	1
D	B	5				C	A	A	10	2
E	A	1				E	A	A	1	1
E	X	15				X	X	X	0	0
F	X	20				E	X	X	15	1
B	F	8				F	X	X	20	1
						B	F	X	8	2

<colgroup><col><col span="5"><col><col><col><col><col></colgroup><tbody>
</tbody>