Spreadsheet: 879445d1726978322-how-to-generate-filtered-vstack-based-on-column-list-repeating-rows-based-on-countif-file2
Sheet: Sheet1

Room ID | Selection Category Description | Product Reference | Labor Take-Off | UM | duplicate | Option 1 | Option 2
LAUNDRY | Floor/Wall | BACKSPLASH | 0 | SF | Base
LAUNDRYALT | Floor/Wall | BACKSPLASH | 0 | SF | Base
KITCH | Floor/Wall | BACKSPLASH | 0 | SF | Base
KITCH | Floor/Wall | BACKSPLASH | 0 | SF | Indirect | CKCA0012 | VSM99016
KITCH | Floor/Wall | BACKSPLASH | 0 | SF | Duplicate | VSM99016 | CKCA0012
KITCH | Floor/Wall | BACKSPLASH | 0 | SF | Indirect | VSM99016
KITCHALT | Floor/Wall | BACKSPLASH | 0 | SF | Base
KITCHALT | Floor/Wall | BACKSPLASH | 0 | SF | Indirect | CKCA0012 | VSM99016
KITCHALT | Floor/Wall | BACKSPLASH | 0 | SF | Duplicate | VSM99016 | CKCA0012
KITCHALT | Floor/Wall | BACKSPLASH | 0 | SF | Indirect | VSM99016
BATH | Cabinets | CABINET | 0 | EA | Base
BATHALT | Cabinets | CABINET | 0 | EA | Base
[NAME] | Cabinets | CABINET | 0 | EA | Base
[NAME] | Cabinets | CABINET | 0 | EA | Base
BATHBED4 | Cabinets | CABINET | 0 | EA | Base
BATHPRIM | Cabinets | CABINET | 0 | EA | Base
BATHPRIMALT | Cabinets | CABINET | 0 | EA | Base
BATHSHAREBED2 | Cabinets | CABINET | 0 | EA | Base
BATHSHAREBED3 | Cabinets | CABINET | 0 | EA | Base
BATHPWD | Cabinets | CABINET | 0 | EA | Indirect | STR08820
LAUNDRY | Cabinets | CABINET | 0 | EA | Base
LAUNDRY | Cabinets | CABINET | 0 | EA | Indirect | STR09070 | STR09060
LAUNDRY | Cabinets | CABINET | 0 | EA | Duplicate | STR09060 | STR09070
LAUNDRY | Cabinets | CABINET | 0 | EA | Indirect | STR09070
LAUNDRY | Cabinets | CABINET | 0 | EA | Indirect | STR09060
LAUNDRYALT | Cabinets | CABINET | 0 | EA | Base
LAUNDRYALT | Cabinets | CABINET | 0 | EA | Indirect | STR09070 | STR09060
LAUNDRYALT | Cabinets | CABINET | 0 | EA | Duplicate | STR09060 | STR09070
LAUNDRYALT | Cabinets | CABINET | 0 | EA | Indirect | STR09070
LAUNDRYALT | Cabinets | CABINET | 0 | EA | Indirect | STR09060
KITCHISL | Cabinets | CABKIT | 0 | EA | Base
KITCHPER | Cabinets | CABKIT | 0 | EA | Base
KITCHPER | Cabinets | CABKIT | 0 | EA | Indirect | CKSX0000
KITCHPER | Cabinets | CABKIT | 0 | EA | Indirect | [NAME]
KITCHPER | Cabinets | CABKIT | 0 | EA | Indirect | CKSX0020
KITCHISLALT | Cabinets | CABKIT | 0 | EA | Base
KITCHPERALT | Cabinets | CABKIT | 0 | EA | Base
KITCHPERALT | Cabinets | CABKIT | 0 | EA | Indirect | CKSX0000
KITCHPERALT | Cabinets | CABKIT | 0 | EA | Indirect | [NAME]
KITCHPERALT | Cabinets | CABKIT | 0 | EA | Indirect | CKSX0020
LAUNDRY | Cabinets | CABSOFT | 0 | EA | Base
LAUNDRY | Cabinets | CABSOFT | 0 | EA | Indirect | STR09070 | STR09060
LAUNDRY | Cabinets | CABSOFT | 0 | EA | Duplicate | STR09060 | STR09070
LAUNDRY | Cabinets | CABSOFT | 0 | EA | Indirect | STR09070
LAUNDRY | Cabinets | CABSOFT | 0 | EA | Indirect | STR09060
LAUNDRYALT | Cabinets | CABSOFT | 0 | EA | Base
LAUNDRYALT | Cabinets | CABSOFT | 0 | EA | Indirect | STR09070 | STR09060
LAUNDRYALT | Cabinets | CABSOFT | 0 | EA | Duplicate | STR09060 | STR09070
LAUNDRYALT | Cabinets | CABSOFT | 0 | EA | Indirect | STR09070
LAUNDRYALT | Cabinets | CABSOFT | 0 | EA | Indirect | STR09060
KITCHPER | Cabinets | CABSOFT | 0 | EA | Base
KITCHPER | Cabinets | CABSOFT | 0 | EA | Indirect | CKSX0000
KITCHPER | Cabinets | CABSOFT | 0 | EA | Indirect | [NAME]
KITCHPER | Cabinets | CABSOFT | 0 | EA | Indirect | CKSX0020
[NAME] | Floor/Wall | CARPET | 0 | SY | Base
BED2ALT | Floor/Wall | CARPET | 0 | SY | Base
BED3 | Floor/Wall | CARPET | 0 | SY | Base
BED3ALT | Floor/Wall | CARPET | 0 | SY | Base
BED4 | Floor/Wall | CARPET | 0 | SY | Base
BED4ALT | Floor/Wall | CARPET | 0 | SY | Base
BED5 | Floor/Wall | CARPET | 0 | SY | Base
BEDPRIM | Floor/Wall | CARPET | 0 | SY | Base
BEDPRIMALT | Floor/Wall | CARPET | 0 | SY | Base
BEDPRIMALT2 | Floor/Wall | CARPET | 0 | SY | Base
[NAME] | Floor/Wall | CARPET | 0 | SY | Base
HALL2NDALT | Floor/Wall | CARPET | 0 | SY | Base
HALL2NDALT2 | Floor/Wall | CARPET | 0 | SY | Base
LOFT | Floor/Wall | CARPET | 0 | SY | Base
LAUNDRYCABWD | Cabinets | COUNTEROTH | 1 | SF | Indirect | CLX50002
LAUNDRYCABWD | Cabinets | COUNTEROTH | 1 | SF | Indirect | CLX50003
LAUNDRYCABWDALT | Cabinets | COUNTEROTH | 1 | SF | Indirect | CLX50002
LAUNDRYCABWDALT | Cabinets | COUNTEROTH | 1 | SF | Indirect | CLX50003
BATH | Cabinets | COUNTERTOP | 0 | SF | Base
BATHALT | Cabinets | COUNTERTOP | 0 | SF | Base
[NAME] | Cabinets | COUNTERTOP | 0 | SF | Base
[NAME] | Cabinets | COUNTERTOP | 0 | SF | Base
BATHBED4 | Cabinets | COUNTERTOP | 0 | SF | Base
BATHPRIM | Cabinets | COUNTERTOP | 0 | SF | Base
BATHPRIMALT | Cabinets | COUNTERTOP | 0 | SF | Base
BATHSHAREBED2 | Cabinets | COUNTERTOP | 0 | SF | Base
BATHSHAREBED3 | Cabinets | COUNTERTOP | 0 | SF | Base
BATH | Cabinets | COUNTERTOP | 0 | SF | Indirect | CTB10002
BATHALT | Cabinets | COUNTERTOP | 0 | SF | Indirect | CTB10002
[NAME] | Cabinets | COUNTERTOP | 0 | SF | Indirect | CTB10002
[NAME] | Cabinets | COUNTERTOP | 0 | SF | Indirect | CTB10002
BATHBED4 | Cabinets | COUNTERTOP | 0 | SF | Indirect | CTB10002
BATHPRIM | Cabinets | COUNTERTOP | 0 | SF | Indirect | CTB10002
BATHPRIMALT | Cabinets | COUNTERTOP | 0 | SF | Indirect | CTB10002
BATHSHAREBED2 | Cabinets | COUNTERTOP | 0 | SF | Indirect | CTB10002
BATHSHAREBED3 | Cabinets | COUNTERTOP | 0 | SF | Indirect | CTB10002
BATHPWD | Cabinets | COUNTERTOP | 0 | SF | Indirect | STR08820
BATHPWD | Cabinets | COUNTERTOP | 0 | SF | Indirect | STR08820 | CTB10002
BATHPWD | Cabinets | COUNTERTOP | 0 | SF | Duplicate | CTB10002 | STR08820
KITCHISL | Cabinets | COUNTERTOP | 0 | SF | Base
KITCHPER | Cabinets | COUNTERTOP | 0 | SF | Base
KITCHISLALT | Cabinets | COUNTERTOP | 0 | SF | Base
KITCHPERALT | Cabinets | COUNTERTOP | 0 | SF | Base
BATH | Cabinets | CTPCREDIT | 0 | EA | Base
BATHALT | Cabinets | CTPCREDIT | 0 | EA | Base
[NAME] | Cabinets | CTPCREDIT | 0 | EA | Base
[NAME] | Cabinets | CTPCREDIT | 0 | EA | Base
BATHBED4 | Cabinets | CTPCREDIT | 0 | EA | Base
BATHSHAREBED2 | Cabinets | CTPCREDIT | 0 | EA | Base
BATHSHAREBED3 | Cabinets | CTPCREDIT | 0 | EA | Base
BATHPWD | Cabinets | CTPCREDIT | 0 | EA | Indirect | STR08820
LAUNDRY | Cabinets | CTPCREDIT | 0 | EA | Base | STR09060
LAUNDRYALT | Cabinets | CTPCREDIT | 0 | EA | Base | STR09060
[NAME] | Floor/Wall | HARDWOOD | 0 | SF | Base
BED2ALT | Floor/Wall | HARDWOOD | 0 | SF | Base
BED3 | Floor/Wall | HARDWOOD | 0 | SF | Base
BED3ALT | Floor/Wall | HARDWOOD | 0 | SF | Base
BED4 | Floor/Wall | HARDWOOD | 0 | SF | Base
BED4ALT | Floor/Wall | HARDWOOD | 0 | SF | Base
BED5 | Floor/Wall | HARDWOOD | 0 | SF | Base
BEDPRIM | Floor/Wall | HARDWOOD | 0 | SF | Base
BEDPRIMALT | Floor/Wall | HARDWOOD | 0 | SF | Base
BEDPRIMALT2 | Floor/Wall | HARDWOOD | 0 | SF | Base
DEN | Floor/Wall | HARDWOOD | 0 | SF | Base
DINING | Floor/Wall | HARDWOOD | 0 | SF | Base
FOYER | Floor/Wall | HARDWOOD | 0 | SF | Base
FOYERALT | Floor/Wall | HARDWOOD | 0 | SF | Base
GARAGEENTRY | Floor/Wall | HARDWOOD | 0 | SF | Base
GREAT | Floor/Wall | HARDWOOD | 0 | SF | Base
GREATALT | Floor/Wall | HARDWOOD | 0 | SF | Base
GREATDIN | Floor/Wall | HARDWOOD | 0 | SF | Base
HALL1ST | Floor/Wall | HARDWOOD | 0 | SF | Base
[NAME] | Floor/Wall | HARDWOOD | 0 | SF | Base
HALL2NDALT | Floor/Wall | HARDWOOD | 0 | SF | Base
HALL2NDALT2 | Floor/Wall | HARDWOOD | 0 | SF | Base
KITCH | Floor/Wall | HARDWOOD | 0 | SF | Base
KITCHALT | Floor/Wall | HARDWOOD | 0 | SF | Base
LOFT | Floor/Wall | HARDWOOD | 0 | SF | Base
MUDROOM | Floor/Wall | HARDWOOD | 0 | SF | Base
MUDROOMALT | Floor/Wall | HARDWOOD | 0 | SF | Base
OFFICEHM | Floor/Wall | HARDWOOD | 0 | SF | Base
OFFICEHMALT | Floor/Wall | HARDWOOD | 0 | SF | Base
STAIRLAND10 | Floor/Wall | HARDWOOD | 0 | SF | Base
STAIRLAND12 | Floor/Wall | HARDWOOD | 0 | SF | Base
[NAME] | Railings | RAIL | 0 | EA | Base
BATHPRIM | Floor/Wall | SHOWERFL | 0 | SF | Base
BATHPRIM | Floor/Wall | SHOWERFL | 0 | SF | Indirect | FLS00001
BATHPRIM | Floor/Wall | SHOWERFL | 0 | SF | Indirect | [NAME]*
BATHPRIM | Floor/Wall | SHOWERFL | 0 | SF | Indirect | [NAME]* | FLS00001
BATHPRIM | Floor/Wall | SHOWERFL | 0 | SF | Duplicate | FLS00001 | [NAME]*
BATHPRIM | Floor/Wall | SHOWERJAMB | 0 | SF | Base
BATHPRIM | Floor/Wall | SHOWERJAMB | 0 | SF | Indirect | STR05100
BATHPRIM | Floor/Wall | SHOWERJAMB | 0 | SF | Indirect | [NAME]*
BATHPRIM | Floor/Wall | SHOWERJAMB | 0 | SF | Indirect | [NAME]* | STR05100
BATHPRIM | Floor/Wall | SHOWERJAMB | 0 | SF | Duplicate | STR05100 | [NAME]*
BATHPRIMALT | Floor/Wall | SHOWERFL | 0 | SF | Base
BATHPRIMALT | Floor/Wall | SHOWERFL | 0 | SF | Indirect | FLS00001
BATHPRIMALT | Floor/Wall | SHOWERFL | 0 | SF | Indirect | [NAME]*
BATHPRIMALT | Floor/Wall | SHOWERFL | 0 | SF | Indirect | [NAME]* | FLS00001
BATHPRIMALT | Floor/Wall | SHOWERFL | 0 | SF | Duplicate | FLS00001 | [NAME]*
BATHPRIMALT | Floor/Wall | SHOWERJAMB | 0 | SF | Base
BATHPRIMALT | Floor/Wall | SHOWERJAMB | 0 | SF | Indirect | STR05100
BATHPRIMALT | Floor/Wall | SHOWERJAMB | 0 | SF | Indirect | [NAME]*
BATHPRIMALT | Floor/Wall | SHOWERJAMB | 0 | SF | Indirect | [NAME]* | STR05100
BATHPRIMALT | Floor/Wall | SHOWERJAMB | 0 | SF | Duplicate | STR05100 | [NAME]*
BATH | Floor/Wall | TILEFLOOR | 0 | SF | Base
BATHALT | Floor/Wall | TILEFLOOR | 0 | SF | Base
[NAME] | Floor/Wall | TILEFLOOR | 0 | SF | Base
[NAME] | Floor/Wall | TILEFLOOR | 0 | SF | Base
BATHBED4 | Floor/Wall | TILEFLOOR | 0 | SF | Base
BATHPRIM | Floor/Wall | TILEFLOOR | 0 | SF | Base
BATHPRIMALT | Floor/Wall | TILEFLOOR | 0 | SF | Base
BATHPWD | Floor/Wall | TILEFLOOR | 0 | SF | Base
BATHSHAREBED2 | Floor/Wall | TILEFLOOR | 0 | SF | Base
BATHSHAREBED3 | Floor/Wall | TILEFLOOR | 0 | SF | Base
FOYER | Floor/Wall | TILEFLOOR | 0 | SF | Base
FOYERALT | Floor/Wall | TILEFLOOR | 0 | SF | Base
GARAGEENTRY | Floor/Wall | TILEFLOOR | 0 | SF | Base
HALL1ST | Floor/Wall | TILEFLOOR | 0 | SF | Base
KITCH | Floor/Wall | TILEFLOOR | 0 | SF | Base
KITCHALT | Floor/Wall | TILEFLOOR | 0 | SF | Base
LAUNDRY | Floor/Wall | TILEFLOOR | 0 | SF | Base
LAUNDRYALT | Floor/Wall | TILEFLOOR | 0 | SF | Base
MUDROOM | Floor/Wall | TILEFLOOR | 0 | SF | Base
MUDROOMALT | Floor/Wall | TILEFLOOR | 0 | SF | Base
STAIRLANDINGTOLL | Floor/Wall | TILEFLOOR | 0 | SF | Base
GREAT | Fireplace | TILESUR | 0 | SF | Indirect | [NAME]
GREAT | Fireplace | TILESUR | 0 | SF | Indirect | FPL00508
GREAT | Fireplace | TILESUR | 0 | SF | Indirect | FPL00504
GREAT | Fireplace | TILESUR | 0 | SF | Indirect | FPL00509
GREATALT | Fireplace | TILESUR | 0 | SF | Indirect | [NAME]
GREATALT | Fireplace | TILESUR | 0 | SF | Indirect | FPL00508
GREATALT | Fireplace | TILESUR | 0 | SF | Indirect | FPL00504
GREATALT | Fireplace | TILESUR | 0 | SF | Indirect | FPL00509
GREATDIN | Fireplace | TILESUR | 0 | SF | Indirect | [NAME]
GREATDIN | Fireplace | TILESUR | 0 | SF | Indirect | FPL00508
GREATDIN | Fireplace | TILESUR | 0 | SF | Indirect | FPL00504
GREATDIN | Fireplace | TILESUR | 0 | SF | Indirect | FPL00509
BATH | Floor/Wall | TILEWALL | 0 | SF | Base
BATH | Floor/Wall | TILEWALL | 0 | SF | Indirect | PLM00901
BATH | Floor/Wall | TILEWALL | 0 | SF | Indirect | PLM00903
BATH | Floor/Wall | TILEWALL | 0 | SF | Indirect | VSM99011
BATHALT | Floor/Wall | TILEWALL | 0 | SF | Base
BATHALT | Floor/Wall | TILEWALL | 0 | SF | Indirect | PLM00901
BATHALT | Floor/Wall | TILEWALL | 0 | SF | Indirect | PLM00903
BATHALT | Floor/Wall | TILEWALL | 0 | SF | Indirect | VSM99011
[NAME] | Floor/Wall | TILEWALL | 0 | SF | Base
[NAME] | Floor/Wall | TILEWALL | 0 | SF | Indirect | PLM00901
[NAME] | Floor/Wall | TILEWALL | 0 | SF | Indirect | PLM00903
[NAME] | Floor/Wall | TILEWALL | 0 | SF | Indirect | VSM99011
[NAME] | Floor/Wall | TILEWALL | 0 | SF | Base
[NAME] | Floor/Wall | TILEWALL | 0 | SF | Indirect | PLM00901
[NAME] | Floor/Wall | TILEWALL | 0 | SF | Indirect | PLM00903
[NAME] | Floor/Wall | TILEWALL | 0 | SF | Indirect | VSM99011
BATHBED4 | Floor/Wall | TILEWALL | 0 | SF | Base
BATHBED4 | Floor/Wall | TILEWALL | 0 | SF | Indirect | PLM00901
BATHBED4 | Floor/Wall | TILEWALL | 0 | SF | Indirect | PLM00903
BATHBED4 | Floor/Wall | TILEWALL | 0 | SF | Indirect | VSM99011
BATHSHAREBED2 | Floor/Wall | TILEWALL | 0 | SF | Base
BATHSHAREBED2 | Floor/Wall | TILEWALL | 0 | SF | Indirect | PLM00901
BATHSHAREBED2 | Floor/Wall | TILEWALL | 0 | SF | Indirect | PLM00903
BATHSHAREBED2 | Floor/Wall | TILEWALL | 0 | SF | Indirect | VSM99011
BATHSHAREBED3 | Floor/Wall | TILEWALL | 0 | SF | Base
BATHSHAREBED3 | Floor/Wall | TILEWALL | 0 | SF | Indirect | PLM00901
BATHSHAREBED3 | Floor/Wall | TILEWALL | 0 | SF | Indirect | PLM00903
BATHSHAREBED3 | Floor/Wall | TILEWALL | 0 | SF | Indirect | VSM99011
BATHPRIM | Floor/Wall | TILEWALL | 0 | SF | Base
BATHPRIM | Floor/Wall | TILEWALL | 0 | SF | Indirect | [NAME]*
BATHPRIMALT | Floor/Wall | TILEWALL | 0 | SF | Base
BATHPRIMALT | Floor/Wall | TILEWALL | 0 | SF | Indirect | [NAME]*
KITCHISL | Cabinets | WATERFALL1 | 1 | LF | Base
KITCHISL | Cabinets | WATERFALL2 | 1 | LF | Base
KITCHPER | Cabinets | WATERFALL1 | 1 | LF | Base
KITCHPER | Cabinets | WATERFALL2 | 1 | LF | Base
KITCHISLALT | Cabinets | WATERFALL1 | 1 | LF | Base
KITCHISLALT | Cabinets | WATERFALL2 | 1 | LF | Base
KITCHPERALT | Cabinets | WATERFALL1 | 1 | LF | Base
KITCHPERALT | Cabinets | WATERFALL2 | 1 | LF | Base