Spreadsheet: 694174d1599409249-condensing-down-like-items-in-a-material-list-2020-09-06-oeldere-fenster-694033d1599311575-condensing-down-like-items-in-a-material-list-ex
Sheet: example

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | These rows are over multiple sheets |  |  |  |  |  |  |  |  | this is combined on one sheet but would like all like items to be condensed before the final list on a separate sheet |  |  |  |  |  |  |  | FINAL LIST pulls all rows with [NAME] (but I want it with the like items combined shown in the section below starting on row 50)
 |  |  |  | data validation list | data validation list | data validation list |  |  |  | Intermediate list |  |  |  |  |  |  |  | IFERROR(INDEX(K$6:K$16,SMALL(IF($L$6:$L$16>$T$2,ROW($K$6:$K$16)-ROW($K$6)+1),ROWS($K$6:$K7))),"")
 |  |  |  |  |  |  |  |  |  | Item | Qty | Size | Color | Material Type |  |  |  | Item | Qty | Size | Color | Material Type
 |  | Top Bolt | 51 | 1-3/4" | black | Stainless Steel
 |  | [NAME] | 61 | 1" | black | Alloy Steel
 |  | Middle Bolt | 4 | 1-1/2" | red | Stainless Steel
 |  | Right Bolt | 12 | 2" | red | Zinc Plated
 |  | Left Bolt | 0 | 1" | green | Alloy Steel
 |  | Outside Bolt | 18 | 1-3/4" | black | Stainless Steel
 |  | Inside Bolt1 | 1 | 1" | green | Stainless Steel
 |  | Inside Bolt2 | 4 | 1" | red | Stainless Steel
 |  | Inside Bolt3 | 31 | 1" | green | Stainless Steel
 |  | Inside Bolt4 | 4 | 1" | green | Stainless Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Item | Qty | Size | Color | Material Type
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Top Bolt | 51 | 1-3/4" | black | Stainless Steel | combined with other black
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 61 | 1" | black | Alloy Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Middle Bolt | 4 | 1-1/2" | red | Stainless Steel | combined with other red
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Right Bolt | 12 | 2" | red | Zinc Plated
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Outside Bolt | 18 | 1-3/4" | black | Stainless Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inside Bolt1 | 1 | 1" | green | Stainless Steel | combined with other green
 |  | Undermount Bolt1 | 16 | 1-1/2" | red | Stainless Steel |  |  |  |  |  |  |  |  |  |  |  | Inside Bolt2 | 4 | 1" | red | Stainless Steel
 |  | Undermount Bolt2 | 8 | 1" | silver | Stainless Steel |  |  |  |  |  |  |  |  |  |  |  | Inside Bolt3 | 31 | 1" | green | Stainless Steel
 |  | Undermount Bolt3 | 4 | 1" | silver | Stainless Steel |  |  |  |  |  |  |  |  |  |  |  | Inside Bolt4 | 4 | 1" | green | Stainless Steel
 |  | Undermount Bolt4 | 16 | 1" | silver | Stainless Steel |  |  |  |  |  |  |  |  |  |  |  | Undermount Bolt1 | 16 | 1-1/2" | red | Stainless Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Undermount Bolt2 | 8 | 1" | silver | Stainless Steel | combine with other blue
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Undermount Bolt3 | 4 | 1" | silver | Stainless Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Undermount Bolt4 | 16 | 1" | silver | Stainless Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Item | Qty | Size | Color | Material Type
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Top Bolt / Outside Bolt | 69 | 1-3/4" | black | Stainless Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 61 | 1" | black | Alloy Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Middle Bolt / Undermount Bolt1 | 20 | 1-1/2" | red | Stainless Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Right Bolt | 12 | 2" | red | Zinc Plated
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inside Bolt1 / Inside Bolt3 /  Inside Bolt4 | 36 | 1" | green | Stainless Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inside Bolt2 | 4 | 1" | red | Stainless Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Undermount Bolt2 / Undermount Bolt3 /  Undermount Bolt4 | 28 | 1" | silver | Stainless Steel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This table is in the middle of a 150+ row List that will all be send to the supplier.  The other rows not shown in the list are ixed and do not need to be combined