Spreadsheet: 882643d1731029873-input-1-to-maybe-7-sku-numbers-to-return-groups-of-rows-find-groups-with-components-jt-v2
Sheet: Sheet1 (2)

Case SKU | Material description | Component | Material description2 | Ratio |  | Component |  | Related Components |  | CF Formula |  | Steps
9800001245 | ASTMNTS CRL SHPR X48 | [PHONE] | ASTMNTS CRL 8.56OZX12 | 48 |  | 9800006353 |  |  |  |  |  | 1 | Unmerge source data and fill up empty cells with texts above
123456789 | ASTMNTS 240CT | 9800006353 | Red | 80 |  | 9800006357 |  | 9800006357 |  |  |  | 2 | [NAME] source data into a Table (Ctrl+T)
 |  | 9800006357 | Blue | 80 |  | 9800006356 |  | 9800006356 |  |  |  | 3 | Create a Table to list the components you want to search, from cell G2 onwards
 |  | 9800006356 | Yellow | 40 |  |  |  | 9800008635 |  |  |  | 4 | Find all related components by applying this formula in cell I2:
 |  | 9800008635 | Green | 40 |  |  |  | 9800006353
9800033873 | ASTMNTS X276 | 9800015503 | Purple | 276 |  |  |  | 9800006357 |  |  |  | 5
9800056677 | ASTMNTS X216 | 9800030528 | teal | 216 |  |  |  | 9800006356 |  |  |  | 6 | Go to source data Table to filter the highlighted cells, if desired
9800028774 | ASTMNTS X288 | 9800015535 | orange | 288 |  |  |  | 9800008635
9800078993 | ASTMNTS X36 | 9800019446 | beige | 36 |  |  |  | 9800006353 |  |  |  | To unmerge cells and fill empty cells with texts above
9800063993 | ASTMNTS  X144 | 9800023584 | white | 144 |  |  |  | 9800006357 |  |  |  | 1 | With cursor anywhere inside the source data > Ctrl+A to select entire range > Unmerge cells
987654321 | ASTMNTS 960ct | 9800006353 | Red | 320 |  |  |  | 9800006356 |  |  |  | 2 | > Ctrl+G > Special > Blanks > OK > Type "=" (without double quotes) then move cursor up 1 time (row) > Ctrl+Enter
 |  | 9800006357 | Blue | 320 |  |  |  | 9800008635 |  |  |  | 3 | > Ctrl+A to select the entire range again > Ctrl+C > Ctrl+Alt+V > Paste Values > OK
 |  | 9800006356 | Yellow | 160
 |  | 9800008635 | Green | 160
986271658 | ASTMNTS X33 | 9862540320 | crunch | 15
 |  | 9862775537 | space | 18
9862710566 | ASTMNTS X36 | 9864121325 | nature | 18
 |  | 9862710138 | butter | 18
9862781065 | ASTMNTS RX33 | 9867770325 | grass | 18
 |  | 9801126984 | fiber | 32
9800028932 | ASTMNTS X156 | 9804423144 | flake | 72
 |  | 9804427010 | giant | 84
654321987 | ASTMNTS CRL 120CT | 9800006353 | Red | 40
 |  | 9800006357 | Blue | 40
 |  | 9800006356 | Yellow | 20
 |  | 9800008635 | Green | 20
9800024446 | ASTMNTS X36 | 9805523856 | snack | 18
 |  | 9800445403 | snacks | 18
Case SKU | Material description | Component | Material description2 | Ratio
123456789 | ASTMNTS 240CT | 9800006357 | Blue | 80
123456789 | ASTMNTS 240CT | 9800006356 | Yellow | 40
123456789 | ASTMNTS 240CT | 9800008635 | Green | 40
987654321 | ASTMNTS 960ct | 9800006353 | Red | 320
987654321 | ASTMNTS 960ct | 9800006357 | Blue | 320
987654321 | ASTMNTS 960ct | 9800006356 | Yellow | 160
987654321 | ASTMNTS 960ct | 9800008635 | Green | 160
654321987 | ASTMNTS CRL 120CT | 9800006353 | Red | 40
654321987 | ASTMNTS CRL 120CT | 9800006357 | Blue | 40
654321987 | ASTMNTS CRL 120CT | 9800006356 | Yellow | 20
654321987 | ASTMNTS CRL 120CT | 9800008635 | Green | 20