Spreadsheet: 883229d1731776789-duplicates-of-multiple-items-in-multiple-bill-of-materials-need-to-be-removed-bom-sample-eba
Sheet: Sheet1

Name | Item | BoM Quantity | Component Yield |  |  |  |  |  |  | Helper
[NAME] 100 | 110-88-10000-23 | 1 | 100 |  |  | 110-88-10000-23 | 1 | 100
[NAME] 100 | 114-88-11222-04 | 0.6 | 100 |  | [NAME] 100 | 114-88-11222-04 | 0.6 | 100
[NAME] 100 | 129-99-10010-43 | 2.9167 | 97 |  | [NAME] 100 | 129-99-10010-43 | 2.9167 | 97
[NAME] 100 | 114-88-00040-09 | 1 | 100 |  | [NAME] 100 | 114-88-00040-09 | 1 | 100
[NAME] 100 | 199-99-15000-01 | 0.4 | 100 |  | [NAME] 100 | 199-99-15000-01 | 0.4 | 100
[NAME] 200 | 110-88-10000-23 | 1 | 100 |  | [NAME] 200 | 110-88-10000-23 | 1 | 100
[NAME] 200 | 114-88-11222-04 | 0.7 | 100 |  | [NAME] 200 | 114-88-11222-04 | 0.7 | 100
[NAME] 200 | 122-99-05470-01 | 2.8333 | 97 |  | [NAME] 200 | 122-99-05470-01 | 2.8333 | 97
[NAME] 200 | 114-88-00040-09 | 1 | 100 |  | [NAME] 200 | 114-88-00040-09 | 1 | 100
[NAME] 200 | 199-99-15000-01 | 0.4 | 100 |  | [NAME] 200 | 199-99-15000-01 | 0.4 | 100
[NAME] 300 | 110-88-10000-23 | 1 | 100 |  | [NAME] 300 | 110-88-10000-23 | 1 | 100
[NAME] 300 | 114-88-11222-04 | 0.7 | 100 |  | [NAME] 300 | 114-88-11222-04 | 0.7 | 100
[NAME] 300 | 129-99-10024-38 | 2.8333 | 97 |  | [NAME] 300 | 129-99-10024-38 | 2.8333 | 97
[NAME] 300 | 114-88-00040-09 | 1 | 100 |  | [NAME] 300 | 114-88-00040-09 | 1 | 100
[NAME] 300 | 199-99-15000-01 | 0.4 | 100 |  | [NAME] 300 | 199-99-15000-01 | 0.4 | 100
[NAME] 400 | 114-88-00040-09 | 1 | 100 |  | [NAME] 400 | 114-88-00040-09 | 1 | 100
[NAME] 400 | 129-99-10010-16 | 2.8333 | 97 |  | [NAME] 400 | 129-99-10010-16 | 2.8333 | 97
[NAME] 400 | 199-99-15000-01 | 0.4 | 100 |  | [NAME] 400 | 199-99-15000-01 | 0.4 | 100
[NAME] 400 | 114-88-11222-04 | 0.7 | 100 |  | [NAME] 400 | 114-88-11222-04 | 0.7 | 100
[NAME] 400 | 110-88-10000-23 | 1 | 100 |  | [NAME] 400 | 110-88-10000-23 | 1 | 100
WIDGET 500 | 110-88-10000-23 | 1 | 100 |  | WIDGET 500 | 110-88-10000-23 | 1 | 100
WIDGET 500 | 114-88-11222-04 | 0.7 | 100 |  | WIDGET 500 | 114-88-11222-04 | 0.7 | 100
WIDGET 500 | 129-99-10010-06 | 2.8333 | 97 |  | WIDGET 500 | 129-99-10010-06 | 2.8333 | 97
WIDGET 500 | 114-88-00040-09 | 1 | 100 |  | WIDGET 500 | 114-88-00040-09 | 1 | 100
WIDGET 500 | 199-99-15000-01 | 0.4 | 100 |  | WIDGET 500 | 199-99-15000-01 | 0.4 | 100
[NAME] 600 | 129-99-10010-43 | 3.0556 | 97 |  | [NAME] 600 | 129-99-10010-43 | 3.0556 | 97
[NAME] 600 | 110-88-10000-23 | 1 | 100 |  | [NAME] 600 | 110-88-10000-23 | 1 | 100
[NAME] 600 | 114-88-00040-09 | 1 | 100 |  | [NAME] 600 | 114-88-00040-09 | 1 | 100
[NAME] 600 | 199-99-15000-01 | 0.4 | 100 |  | [NAME] 600 | 199-99-15000-01 | 0.4 | 100
[NAME] 600 | 114-88-11222-04 | 0.2 | 100 |  | [NAME] 600 | 114-88-11222-04 | 0.2 | 100
[NAME] 700 | 114-88-22223-13 | 0.2111 | 97
[NAME] 700 | 114-88-22223-13 | 0.2111 | 97
[NAME] 700 | 110-88-10000-23 | 1 | 100
[NAME] 700 | 126-88-03000-05 | 2.2778 | 97
[NAME] 700 | 126-88-03000-05 | 2.2778 | 97
[NAME] 700 | 129-99-10010-43 | 0.3611 | 97
[NAME] 700 | 129-99-10010-43 | 0.3611 | 97
[NAME] 700 | 199-99-15000-01 | 0.4 | 100
[NAME] 700 | 114-88-11222-04 | 0.25 | 100
[NAME] 700 | 114-88-11222-04 | 0.25 | 100
[NAME] 700 | 114-88-00040-09 | 1 | 100
[NAME] 700 | 114-88-11112-36 | 2 | 100
[NAME] 700 | 114-88-11112-82 | 2 | 100
[NAME] 700 | 114-88-11112-36 | 2 | 100
[NAME] 700 | 114-88-11112-82 | 2 | 100
[NAME] 700 | 114-88-11112-86 | 1.777800001828806 | 100
[NAME] 700 | 199-99-15000-01 | 0.4 | 100
[NAME] 700 | 114-88-00040-09 | 1 | 100
[NAME] 700 | 110-88-10000-23 | 1 | 100
[NAME] 700 | 114-88-11112-86 | 1.777800001828806 | 100