See attached for a file that has a very small sample of lines. The actual file will have around 70,000 rows with around 9,000 BOMs. Look at column A for the structure. "BOM" in the first column indicates the start of a new Bill of Material. The rows following are instructions in creating the BOM. The order of these rows cannot be changed since this is the order in which the product is to be assembled in. We need to eliminate (delete) any rows within the file that add an item starting with "BX-". You'll see examples of this on row 10, 16, 23, 31, and 69. The files that I receive back from you will need to be less than 5,000 rows in length but should contain complete BOMs. (Don't cut any BOM in half at the end of any file) This means that I'll receive around 15 files back from you for import. The project will be something that will be completed over the weekend. The company uses their data during the day so I'll be exporting the information from their system after hours and then sending along to you and will get them to you on Friday evening. I'll be importing the files back into their system when I receive them back from you so I'll need them by Sunday morning at the latest.
## Deliverables
1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).
## Platform
Excel 2003 or 2007 on Windows.