Spreadsheet: 739885d1626056218-how-to-filter-and-retain-data-filter-data-based-on-values-in-different-columns-rayted-
Sheet: 0807_SRM_ClientCopy

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sub Adgate |  | Type |  | Sub Adgate | Type
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chilled- Continental Meats |  | Amb- [NAME] Peppers |  | Chilled- Continental Meats | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Amb- Antipasti | Amb- [NAME] Sun Dried Tom
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chilled- Sliced Cooked Meats | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chilled- Antipasti | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chld Antpsti- Single Item
 |  |  | Chilled | Not Applicable | Deluxe | Not Applicable | Not Applicable | Not Applicable | Sliced | American | Smoked Bbq | Not Applicable | Not Applicable | Non Protein | Not Applicable | Standard | Standard | Standard |  | Not Applicable | Not Stated | Not Applicable | Not Applicable | Not Applicable | Prepacked | Beef | Not Applicable | Deluxe | All Year Round | Single | 130 Gm | Smoked | Chilled- Continental Meats | 1 Pack | [NAME] |  |  | Chl SCM- Regional/Trad
Peppers | Not Applicable | Ambient | Ambient | Not Applicable | Disco | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Italian | Roasted | Not Applicable | Not Applicable | Non Protein | Not Applicable | Standard | Standard | Standard |  | Plastic | Not Applicable | Jar | Not Applicable | Not Applicable | Prepacked | Not Applicable | Not Applicable | Deli Discoveries | All Year Round | Single | 200 Gm |  | Amb- Antipasti | 1 Pack | Amb- [NAME] Peppers |  |  | Amb- [NAME] Peppers
Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8 | Column 9 | Column 10 | Column 11 | Column 12 | Column 13 | Column 14 | Column 15 | Column 16 | Column 17 | Column 18 | Column 19 | Column 20 | Column 21 | Column 22 | Column 23 | Column 24 | Column 25 | Column 26 | Column 27 | Column 28 | Column 29 | Column 30 | Column 31 | Column 32 | Column 33 | Sub Adgate | Column 35 | Type | Filter
 |  |  | Chilled | Not Applicable | Deluxe | Not Applicable | Not Applicable | Not Applicable | Sliced | American | Smoked Bbq | Not Applicable | Not Applicable | Non Protein | Not Applicable | Standard | Standard | Standard |  | Not Applicable | Not Stated | Not Applicable | Not Applicable | Not Applicable | Prepacked | Beef | Not Applicable | Deluxe | All Year Round | Single | 130 Gm | Smoked | Chilled- Continental Meats | 1 Pack | [NAME]
Tomatoes | Not Applicable | Ambient | Ambient | Not Applicable | [NAME] | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Italian | Standard | Not Applicable | Not Applicable | Non Protein | Not Applicable | Standard | Standard | Standard |  | Not Applicable | Not Applicable | Jar | Not Applicable | Not Applicable | Prepacked | Not Applicable | Not Applicable | Lidl | All Year Round | Single | 300 Gm |  | Amb- Antipasti | 1 Pack | Amb- [NAME] Sun Dried Tom
 |  |  | Chilled | Not Applicable | Market | Not Applicable | Not Applicable | Not Applicable | Sliced | English | Crumbed | Not Applicable | Not Applicable | Non Protein | Not Applicable | Standard | Standard | Standard |  | Not Applicable | 12 Slices | Not Applicable | Not Applicable | Not Applicable | Prepacked | Ham | Not Applicable | J.James & Family | All Year Round | Single | 300 Gm | Unsmoked | Chilled- Sliced Cooked Meats | 1 Pack | [NAME]
 |  |  | Chilled | Not Applicable | Jacks | Not Applicable | Not Applicable | Not Applicable | Sliced | English | Roast | Not Applicable | Not Applicable | Non Protein | Not Applicable | Standard | Standard | Standard |  | Not Applicable | 24 Slices | Not Applicable | Not Applicable | Not Applicable | Prepacked | Chicken | Non-Corn Fed | Jacks | All Year Round | Single | 250 Gm | Unsmoked | Chilled- Sliced Cooked Meats | 1 Pack | [NAME]
Tomatoes | Not Applicable | Chilled | Chilled | Not Applicable | Dunnes | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Italian | Semi Dried Tomatoes | Not Applicable | Not Applicable | Non Protein | Not Applicable | Standard | Standard | Standard |  | Not Applicable | Not Applicable | Tub | Not Applicable | Not Applicable | Prepacked | Not Applicable | Not Applicable | Dunnes | All Year Round | Single | 120 Gm |  | Chilled- Antipasti | 1 Pack | Chld Antpsti- Single Item
 |  |  | Chilled | Not Applicable | New | Not Applicable | Not Applicable | Not Applicable | Sliced | English | Plain | Not Applicable | Not Applicable | Non Protein | Not Applicable | Standard | Standard | Standard |  | Not Applicable | 3 Slices | Not Applicable | Not Applicable | Not Applicable | Prepacked | Ham | Not Applicable | Aldi Specially Selected | All Year Round | Single | 100 Gm | Unsmoked | Chilled- Sliced Cooked Meats | 1 Pack | Chl SCM- Regional/Trad
Peppers | Not Applicable | Ambient | Ambient | Not Applicable | Disco | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Italian | Roasted | Not Applicable | Not Applicable | Non Protein | Not Applicable | Standard | Standard | Standard |  | Plastic | Not Applicable | Jar | Not Applicable | Not Applicable | Prepacked | Not Applicable | Not Applicable | Deli Discoveries | All Year Round | Single | 200 Gm |  | Amb- Antipasti | 1 Pack | Amb- [NAME] Peppers
Tomatoes | Not Applicable | Ambient | Ambient | Not Applicable | Dunnies | Not Applicable | Not Applicable | Not Applicable | Not Applicable | Italian | Standard | Not Applicable | Not Applicable | Non Protein | Not Applicable | Standard | Standard | Standard |  | Not Applicable | Not Applicable | Jar | Not Applicable | Not Applicable | Prepacked | Not Applicable | Not Applicable | Dunnes [NAME] | All Year Round | Single | 290 Gm |  | Amb- Antipasti | 1 Pack | Amb- [NAME] Sun Dried Tom