Spreadsheet: 879446d1726978331-how-to-generate-filtered-vstack-based-on-column-list-repeating-rows-based-on-countif-file3
Sheet: Sheet1

Room ID | Selection Category Description | Product Reference | Labor Take-Off | UM | duplicate | Option 1 | Option 2 | Plan | Elev | Room ID
BATH | Cabinets | CABINET | 0 | EA | Base | 0 | 0 | Q30D | EM | BATH
BATH | Cabinets | COUNTERTOP | 0 | SF | Base | 0 | 0 | Q30D | EM | BATH
BATH | Cabinets | COUNTERTOP | 0 | SF | Indirect | CTB10002 | 0 | Q30D | EM | BATH
BATH | Cabinets | CTPCREDIT | 0 | EA | Base | 0 | 0 | Q30D | EM | BATH
BATH | Floor/Wall | TILEFLOOR | 0 | SF | Base | 0 | 0 | Q30D | EM | BATH
BATH | Floor/Wall | TILEWALL | 0 | SF | Base | 0 | 0 | Q30D | EM | BATH
BATH | Floor/Wall | TILEWALL | 0 | SF | Indirect | PLM00901 | 0 | Q30D | EM | BATH
BATH | Floor/Wall | TILEWALL | 0 | SF | Indirect | PLM00903 | 0 | Q30D | EM | BATH
BATH | Floor/Wall | TILEWALL | 0 | SF | Indirect | VSM99011 | 0 | Q30D | EM | BATH
 | Cabinets | CABINET | 0 | EA | Base | 0 | 0 | Q30D | MO | BATH
BATH | Cabinets | COUNTERTOP | 0 | SF | Base | 0 | 0 | Q30D | MO | BATH
BATH | Cabinets | COUNTERTOP | 0 | SF | Indirect | CTB10002 | 0 | Q30D | MO | BATH
BATH | Cabinets | CTPCREDIT | 0 | EA | Base | 0 | 0 | Q30D | MO | BATH
BATH | Floor/Wall | TILEFLOOR | 0 | SF | Base | 0 | 0 | Q30D | MO | BATH
BATH | Floor/Wall | TILEWALL | 0 | SF | Base | 0 | 0 | Q30D | MO | BATH
BATH | Floor/Wall | TILEWALL | 0 | SF | Indirect | PLM00901 | 0 | Q30D | MO | BATH
BATH | Floor/Wall | TILEWALL | 0 | SF | Indirect | PLM00903 | 0 | Q30D | MO | BATH
BATH | Floor/Wall | TILEWALL | 0 | SF | Indirect | VSM99011 | 0 | Q30D | MO | BATH
BATHALT | Cabinets | CABINET | 0 | EA | Base | 0 | 0 | Q30D | EM | BATHALT
BATHALT | Cabinets | COUNTERTOP | 0 | SF | Base | 0 | 0 | Q30D | EM | BATHALT
BATHALT | Cabinets | COUNTERTOP | 0 | SF | Indirect | CTB10002 | 0 | Q30D | EM | BATHALT
BATHALT | Cabinets | CTPCREDIT | 0 | EA | Base | 0 | 0 | Q30D | EM | BATHALT
BATHALT | Floor/Wall | TILEFLOOR | 0 | SF | Base | 0 | 0 | Q30D | EM | BATHALT
BATHALT | Floor/Wall | TILEWALL | 0 | SF | Base | 0 | 0 | Q30D | EM | BATHALT
BATHALT | Floor/Wall | TILEWALL | 0 | SF | Indirect | PLM00901 | 0 | Q30D | EM | BATHALT
BATHALT | Floor/Wall | TILEWALL | 0 | SF | Indirect | PLM00903 | 0 | Q30D | EM | BATHALT
BATHALT | Floor/Wall | TILEWALL | 0 | SF | Indirect | VSM99011 | 0 | Q30D | EM | BATHALT
 | Cabinets | CABINET | 0 | EA | Base | 0 | 0 | Q30D | TA | BATHPRIMALT
BATHPRIMALT | Cabinets | COUNTERTOP | 0 | SF | Base | 0 | 0 | Q30D | TA | BATHPRIMALT
BATHPRIMALT | Cabinets | COUNTERTOP | 0 | SF | Indirect | CTB10002 | 0 | Q30D | TA | BATHPRIMALT
BATHPRIMALT | Floor/Wall | SHOWERFL | 0 | SF | Base | 0 | 0 | Q30D | TA | BATHPRIMALT
BATHPRIMALT | Floor/Wall | SHOWERFL | 0 | SF | Indirect | FLS00001 | 0 | Q30D | TA | BATHPRIMALT
BATHPRIMALT | Floor/Wall | SHOWERFL | 0 | SF | Indirect | [NAME]* | 0 | Q30D | TA | BATHPRIMALT
BATHPRIMALT | Floor/Wall | SHOWERFL | 0 | SF | Indirect | [NAME]* | FLS00001 | Q30D | TA | BATHPRIMALT
BATHPRIMALT | Floor/Wall | SHOWERFL | 0 | SF | Duplicate | FLS00001 | [NAME]* | Q30D | TA | BATHPRIMALT
BATHPRIMALT | Floor/Wall | SHOWERJAMB | 0 | SF | Base | 0 | 0 | Q30D | TA | BATHPRIMALT
BATHPRIMALT | Floor/Wall | SHOWERJAMB | 0 | SF | Indirect | STR05100 | 0 | Q30D | TA | BATHPRIMALT
BATHPRIMALT | Floor/Wall | SHOWERJAMB | 0 | SF | Indirect | [NAME]* | 0 | Q30D | TA | BATHPRIMALT
BATHPRIMALT | Floor/Wall | SHOWERJAMB | 0 | SF | Indirect | [NAME]* | STR05100 | Q30D | TA | BATHPRIMALT
BATHPRIMALT | Floor/Wall | SHOWERJAMB | 0 | SF | Duplicate | STR05100 | [NAME]* | Q30D | TA | BATHPRIMALT
BATHPRIMALT | Floor/Wall | TILEFLOOR | 0 | SF | Base | 0 | 0 | Q30D | TA | BATHPRIMALT
BATHPRIMALT | Floor/Wall | TILEWALL | 0 | SF | Base | 0 | 0 | Q30D | TA | BATHPRIMALT
BATHPRIMALT | Floor/Wall | TILEWALL | 0 | SF | Indirect | [NAME]* | 0 | Q30D | TA | BATHPRIMALT