Rearrange Customer Supplied Bill of Material.Use the select button to enter an Excel file. (.xlsx and .xls both work)
Enter starting Component ID, Part Number, and Quantity cells. Ex Q7. Input can be lower or upper case.
Use the select button to enter the new directory.
Type in the name of the new file. If you do not include an extension, it will automatically be .xlsx.
After clicking the Start button, the program will go through all part numbers and group all component IDs together in one line.
It will also add all quantities together.
The program will then save the Excel file and then open it automatically.