show me how to do a BOM from Excel Bid

I have a detailed bid sheet sitting in Excel and I need it converted into a clean, stand-alone Bill of Materials. The only data that must be carried over for every line is the quantity, and I want the... (Budget: $15 - $25 USD, Jobs: Data Analysis, Data Annotation, Data Entry, Data Management, Data Processing, Electrical Engineering, Engineering, Excel)