Hello,
I have a parts list that has many duplicate items, but different lengths for each piece to be cut at. when referring from this bill of materials to enter into the computer, i only need to enter one line with the total quantity. Each parts list is of varying lengths and random orders. I am hoping to find something that will scrape the list for similar parts and condense them.
Sample below. I would like line item# 1,2, and 3 to be condensed into one line, for total length of 12592mm (that multiplies qty in B2 by length in d2, and sums all similar woods from line c into one line). ideally, it would be great if this pops out the info on a new sheet, but i would be fine with it in column J-- or any column further to the right.
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
desired end result
J column K column (or on new sheet)
Mahogany 12592mm
White Oak 15744mm
I have a parts list that has many duplicate items, but different lengths for each piece to be cut at. when referring from this bill of materials to enter into the computer, i only need to enter one line with the total quantity. Each parts list is of varying lengths and random orders. I am hoping to find something that will scrape the list for similar parts and condense them.
Sample below. I would like line item# 1,2, and 3 to be condensed into one line, for total length of 12592mm (that multiplies qty in B2 by length in d2, and sums all similar woods from line c into one line). ideally, it would be great if this pops out the info on a new sheet, but i would be fine with it in column J-- or any column further to the right.
Item # | QTY | Description | Part Number | Length [mm] |
1 | 4 | mahogany | MHG887 | 1000 |
2 | 4 | mahogany | MHG887 | 1299 |
3 | 6 | mahogany | MHG887 | 566 |
4 | 12 | white oak | WO992 | 1312 |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
desired end result
J column K column (or on new sheet)
Mahogany 12592mm
White Oak 15744mm