Spreadsheet: 97628d1296753319-need-help-pulling-catalog-data-into-usable-format-catalog
Sheet: Sample Catalog

Widget Industries Price List - Effective: 12/9/2010
Widget Industries # | Category | Catalog Page # | Color Group | [NAME] | Pieces per Case | Case Price | Dozen Price | Piece Price
10210 | Product Description -10210 | 8 | Colors | S - XL | 24 | 23.16 | 26.63 | 30.11
 |  |  |  | 2XL - 3XL | 24 | 25.54 | 29.37 | 33.2
Widget Industries # | Category | Catalog Page # | Color Group | [NAME] | Pieces per Case | Case Price | Dozen Price | Piece Price
10211 | Product Description -10211 | 16 | Colors | LT | 12 | 18.53 | 21.31 | 24.09
 |  |  |  | XLT | 12 | 20.3 | 23.35 | 26.39
 |  |  |  | 2XT | 12 | 22.05 | 25.36 | 28.67
10212 | Product Description -10212 | 16 | Colors | XS - XL | 12 | 14.04 | 16.15 | 18.25
 |  |  |  | 2XL - 3XL | 12 | 16.76 | 19.27 | 21.79
10213 | Product Description -10213 | 16 | Colors | XS - XL | 12 | 13.99 | 16.09 | 18.19
 |  |  |  | 2XL - 3XL | 12 | 16.67 | 19.17 | 21.67
10214 | Product Description -10214 | 18 | Colors | S - XL | 12 | 11.32 | 13.02 | 14.72
 |  |  |  | 2XL - 3XL | 12 | 13.57 | 15.61 | 17.64
 |  |  |  | 4XL | 6 | 14.92 | 17.16 | 19.4
 |  |  |  | 5XL | 3 | 16.25 | 18.69 | 21.13
 |  |  |  | 6XL | 3 | 17.52 | 20.15 | 22.78
Widget Industries # | Category | Catalog Page # | Color Group | [NAME] | Pieces per Case | Case Price | Dozen Price | Piece Price
20212 | Product Description -20212 | 110 | White | S - XL | 72 | 1 | 1.98 | 2.24
 |  |  |  | 2XL | 72 | 2 | 3.23 | 3.65
 |  |  |  | 3XL | 36 | 3 | 3.23 | 3.65
 |  |  |  | 4XL - 5XL | 12 | 4 | 3.23 | 3.65
 |  |  | Neutrals | S - XL | 72 | 5 | 1.98 | 2.24
 |  |  |  | 2XL | 72 | 6 | 3.23 | 3.65
 |  |  |  | 3XL | 36 | 7 | 3.23 | 3.65
 |  |  | Heathers | S - XL | 72 | 8 | 2.61 | 2.95
 |  |  |  | 2XL | 72 | 9 | 3.92 | 4.43
 |  |  |  | 3XL | 36 | 10 | 3.92 | 4.43
 |  |  |  | 4XL - 5XL | 12 | 11 | 3.92 | 4.43
 |  |  | Colors | S - XL | 72 | 12 | 2.86 | 3.24
 |  |  |  | 2XL | 72 | 13 | 4.38 | 4.95
 |  |  |  | 3XL | 36 | 14 | 4.38 | 4.95
 |  |  |  | 4XL - 5XL | 12 | 15 | 4.38 | 4.95
 |  |  | PFD | S - XL | 72 | 16 | 2.05 | 2.31
 |  |  |  | 2XL | 72 | 17 | 3 | 3.39
 |  |  |  | 3XL | 36 | 18 | 3 | 3.39
20215 | Product Description -20215 | 18 | Colors | S - XL | 12 | 10.95 | 12.59 | 14.24
 |  |  |  | 2XL - 3XL | 12 | 13.17 | 15.15 | 17.12
 |  |  |  | 4XL | 6 | 14.45 | 16.62 | 18.79
 |  |  |  | 5XL | 3 | 15.58 | 17.92 | 20.25
 |  |  |  | 6XL | 3 | 16.97 | 19.52 | 22.06
20227 | Product Description -20227 | 18 | Colors | LT | 12 | 13.97 | 16.07 | 18.16
 |  |  |  | XLT | 12 | 15.32 | 17.62 | 19.92
 |  |  |  | 2XT | 12 | 16.83 | 19.35 | 21.88
36549 | Product Description -36549 | 36 | Colors | S - XL | 24 | 31.99 | 36.79 | 41.59
 |  |  |  | 2XL | 24 | 35.8 | 41.17 | 46.54
 |  |  |  | 3XL | 24 | 36.81 | 42.33 | 47.85
36548 | Product Description -36548 | 74 | Colors | S - XL | 36 | 9.72 | 11.18 | 12.64
 |  |  |  | 2XL | 24 | 11.24 | 12.93 | 14.61
 |  |  |  | 3XL | 12 | 12.81 | 14.73 | 16.65
 |  |  |  | 4XL | 12 | 14.28 | 16.42 | 18.56
 |  |  |  | 5XL | 12 | 15.99 | 18.39 | 20.79
99292 | Product Description -99292 | 39 | Colors | S - XL | 24 | 29.99 | 34.49 | 38.99
 |  |  |  | 2XL | 24 | 33.5 | 38.53 | 43.55
 |  |  |  | 3XL | 24 | 35.5 | 40.83 | 46.15
87854 | Product Description -87854 | 39 | Colors | S - XL | 24 | 29.99 | 34.49 | 38.99
 |  |  |  | 2XL | 24 | 33.29 | 38.28 | 43.28
87595 | Product Description -87595 | 39 | Colors | S - XL | 24 | 29.99 | 34.49 | 38.99
 |  |  |  | 2XL | 24 | 32.99 | 37.94 | 42.89
 |  |  |  | 3XL | 24 | 34.99 | 40.24 | 45.49
66222 | Product Description -66222 | 39 | Colors | S - XL | 24 | 29.99 | 34.49 | 38.99
 |  |  |  | 2XL | 24 | 33.39 | 38.4 | 43.41
66223 | Product Description -66223 | 40 | Colors | S - XL | 24 | 27.85 | 32.03 | 36.21
 |  |  |  | 2XL | 24 | 30.91 | 35.55 | 40.18
 |  |  |  | 3XL | 24 | 33.07 | 38.03 | 42.99