Spreadsheet: 875054d1721624739-how-to-split-into-part-from-a-set-of-data-help
Sheet: Sheet1

 |  |  | Data |  |  |  |  | Result that I need to be automatically split into different part categorized by supplier.
 |  |  | Code 1 | Supplier | Weigh | Price |  | Supplier | Code 1 | Weight | Price |  | Supplier | Code 1 | Weight | Price |  | Supplier | Code 1 | Weight | Price
 |  |  | T1031 | ANT5-2 | 433 | 7400 |  | AC5-3 | T918 | 7800 | 9600 |  | ANT4-2 | U152 | 1845 | 7500 |  | BL3-4 | U35 | 1528 | 7700
 |  |  | T1039 | ANT5-2 | 3268 | 7900 |  | AC5-3 | T920 | 6520 | 9200 |  | ANT4-3 | T646 | 3670 | 9200 |  | BL7-1 | U315 | 1274 | 8500
 |  |  | T1060 | AC5-4 | 6035 | 7300 |  | AC5-4 | T1060 | 6035 | 7300 |  | ANT4-3 | T658 | 6340 | 8200 |  | BL7-1 | U286 | 3183 | 8500
 |  |  | T1061 | AC5-4 | 6070 | 7300 |  | AC5-4 | T1061 | 6070 | 7300 |  | ANT4-3 | T1105 | 4779 | 8000 |  | BL7-1 | U316 | 2023 | 8100
 |  |  | T1062 | AC5-4 | 7240 | 7600 |  | AC5-4 | T1062 | 7240 | 7600 |  | ANT4-3 | U148 | 5179 | 7100 |  | BL7-1 | U287 | 1896 | 8000
 |  |  | T646 | ANT4-3 | 3670 | 9200 |  | AC5-4 | T1057 | 6460 | 8600 |  | ANT4-3 | U147 | 3953 | 7100 |  | BL7-1 | U301 | 1004 | 7500
 |  |  | T658 | ANT4-3 | 6340 | 8200 |  | AC5-4 | T1054 | 6730 | 9200 |  | ANT5-1 | T821 | 6805 | 9300 |  | BL7-1 | U344 | 989 | 8000
 |  |  | T821 | ANT5-1 | 6805 | 9300 |  | AC6-1 | U194 | 3614 | 8300 |  | ANT5-2 | T1031 | 433 | 7400 |  | BL7-1 | U322 | 1970 | 8000
 |  |  | T918 | AC5-3 | 7800 | 9600 |  | AC6-2 | U206 | 5490 | 7700 |  | ANT5-2 | T1039 | 3268 | 7900
 |  |  | T920 | AC5-3 | 6520 | 9200 |  | AC6-2 | U205 | 6525 | 7700 |  | ANT5-2 | T993 | 5945 | 8600
 |  |  | T993 | ANT5-2 | 5945 | 8600 |  | AC6-2 | U202 | 6560 | 9200 |  | ANT5-2 | T998 | 6665 | 7450 |  | Supplier | Code 1 | Weight | Price
 |  |  | T998 | ANT5-2 | 6665 | 7450 |  | AC6-2 | U220 | 1894 | 8000 |  | ANT5-2 | T991 | 3900 | 9300 |  | EV7-1 | U486 | 5180 | 9100
 |  |  | T991 | ANT5-2 | 3900 | 9300 |  | AC6-2 | U215 | 2063 | 8200 |  | ANT5-2 | U159 | 4385 | 7100 |  | EV7-1 | U487 | 5203 | 9100
 |  |  | T1105 | ANT4-3 | 4779 | 8000 |  | AC7-1 | U392 | 7080 | 8600 |  | ANT5-2 | U157 | 1039 | 7300 |  | EV7-1 | U511 | 4009 | 8000
 |  |  | T1057 | AC5-4 | 6460 | 8600 |  | AC7-1 | U393 | 6710 | 8600 |  | ANT5-2 | T989 | 205 | 9300 |  | EV7-1 | U501 | 2083 | 6600
 |  |  | U69 | ANT6-1 | 6620 | 9200 |  | AC7-1 | U391 | 5450 | 7600 |  | ANT5-2 | T992 | 190 | 8600
 |  |  | U81 | ANT6-1 | 6995 | 7350 |  | AC7-1 | U432 | 6585 | 6600 |  | ANT6-1 | U69 | 6620 | 9200
 |  |  | T1054 | AC5-4 | 6730 | 9200 |  | AC7-1 | U435 | 7625 | 7600 |  | ANT6-1 | U81 | 6995 | 7350 |  | Supplier | Code 1 | Weight | Price
 |  |  | U35 | BL3-4 | 1528 | 7700 |  | AC7-1 | U403 | 6295 | 7000 |  | ANT6-1 | U72 | 4110 | 8500 |  | JLN7-1 | U505 | 200 | 7700
 |  |  | U72 | ANT6-1 | 4110 | 8500 |  | AC7-1 | U378 | 6655 | 7000 |  | ANT6-1 | U121 | 6107 | 7400
 |  |  | U121 | ANT6-1 | 6107 | 7400 |  | AC7-1 | U380 | 6945 | 6300 |  | ANT6-1 | U120 | 5587 | 7400
 |  |  | U120 | ANT6-1 | 5587 | 7400 |  |  | Total |  |  |  | ANT6-1 | U143 | 8113 | 6700
 |  |  | U152 | ANT4-2 | 1845 | 7500 |  |  |  |  |  |  | ANT6-1 | U127 | 3175 | 8000 |  | Supplier | Code 1 | Weight | Price
 |  |  | U148 | ANT4-3 | 5179 | 7100 |  |  |  |  |  |  | ANT6-1 | U135 | 3522 | 7900 |  | SHE7-1 | U369 | 5226 | 8400
 |  |  | U206 | AC6-2 | 5490 | 7700 |  |  |  |  |  |  | ANT6-1 | U70 | 325 | 8600 |  | SHE7-1 | U349 | 5987 | 7800
 |  |  | U205 | AC6-2 | 6525 | 7700 |  |  |  |  |  |  | ANT6-1 | U132 | 447 | 8000 |  | SHE7-1 | U368 | 5414 | 6800
 |  |  | U202 | AC6-2 | 6560 | 9200 |  |  |  |  |  |  | ANT7-1 | U468 | 7435 | 6600
 |  |  | U143 | ANT6-1 | 8113 | 6700 |  |  |  |  |  |  | ANT7-1 | U515 | 2403 | 8000
 |  |  | U147 | ANT4-3 | 3953 | 7100 |  |  |  |  |  |  | ANT7-1 | U526 | 2161 | 7100
 |  |  | U159 | ANT5-2 | 4385 | 7100 |  |  |  |  |  |  | ANT7-1 | U520 | 3458 | 7000
 |  |  | U127 | ANT6-1 | 3175 | 8000 |  |  |  |  |  |  | ANT7-1 | U532 | 729 | 6800
 |  |  | U220 | AC6-2 | 1894 | 8000 |  |  |  |  |  |  | ANT7-2 | U595 | 1746 | 8000
 |  |  | U215 | AC6-2 | 2063 | 8200 |  |  |  |  |  |  | ANT7-2 | U599 | 2602 | 7100
 |  |  | U194 | AC6-1 | 3614 | 8300 |  |  |  |  |  |  | ANT7-2 | U607 | 2575 | 6900
 |  |  | U135 | ANT6-1 | 3522 | 7900 |  |  |  |  |  |  | ANT7-2 | U606 | 1234 | 7900
 |  |  | U157 | ANT5-2 | 1039 | 7300 |  |  |  |  |  |  | ANT7-2 | U602 | 446 | 6800
 |  |  | T989 | ANT5-2 | 205 | 9300 |  |  |  |  |  |  | ANT7-2 | U609 | 2058 | 6700
 |  |  | T992 | ANT5-2 | 190 | 8600 |  |  |  |  |  |  | ANT7-2 | U613 | 2680 | 7000
 |  |  | U70 | ANT6-1 | 325 | 8600 |  |  |  |  |  |  |  | Total
 |  |  | U132 | ANT6-1 | 447 | 8000
 |  |  | U369 | SHE7-1 | 5226 | 8400
 |  |  | U315 | BL7-1 | 1274 | 8500
 |  |  | U286 | BL7-1 | 3183 | 8500
 |  |  | U349 | SHE7-1 | 5987 | 7800
 |  |  | U316 | BL7-1 | 2023 | 8100
 |  |  | U287 | BL7-1 | 1896 | 8000
 |  |  | U368 | SHE7-1 | 5414 | 6800
 |  |  | U301 | BL7-1 | 1004 | 7500
 |  |  | U344 | BL7-1 | 989 | 8000
 |  |  | U322 | BL7-1 | 1970 | 8000
 |  |  | U392 | AC7-1 | 7080 | 8600
 |  |  | U393 | AC7-1 | 6710 | 8600
 |  |  | U391 | AC7-1 | 5450 | 7600
 |  |  | U432 | AC7-1 | 6585 | 6600
 |  |  | U435 | AC7-1 | 7625 | 7600
 |  |  | U403 | AC7-1 | 6295 | 7000
 |  |  | U378 | AC7-1 | 6655 | 7000
 |  |  | U380 | AC7-1 | 6945 | 6300
 |  |  | U505 | JLN7-1 | 200 | 7700
 |  |  | U486 | EV7-1 | 5180 | 9100
 |  |  | U487 | EV7-1 | 5203 | 9100
 |  |  | U468 | ANT7-1 | 7435 | 6600
 |  |  | U511 | EV7-1 | 4009 | 8000
 |  |  | U515 | ANT7-1 | 2403 | 8000
 |  |  | U526 | ANT7-1 | 2161 | 7100
 |  |  | U520 | ANT7-1 | 3458 | 7000
 |  |  | U532 | ANT7-1 | 729 | 6800
 |  |  | U501 | EV7-1 | 2083 | 6600
 |  |  | U595 | ANT7-2 | 1746 | 8000
 |  |  | U599 | ANT7-2 | 2602 | 7100
 |  |  | U607 | ANT7-2 | 2575 | 6900
 |  |  | U606 | ANT7-2 | 1234 | 7900
 |  |  | U602 | ANT7-2 | 446 | 6800
 |  |  | U609 | ANT7-2 | 2058 | 6700
 |  |  | U613 | ANT7-2 | 2680 | 7000