Prep CR2 Data Spreadsheet for Easy Catalog Merge

  1. Download from PTC to Excel "Product Info - CR2"
  2. Delete 1st row
  3. Title Column A "Primary"
    1. Change Data Type to "General"
    2. Concatenate "Work # and Colorway Letter with a Hyphen between to two
      1. =CONCATENATE(F2,"-",G2)
      2. Copy this formula for all cells
    3. Remove the Duplicates
      1. Highlight all data
      2. In the ribbon choose Data -> Remove Duplicates
        1. Remove Duplicate from Column Primary
  4. Delete rows where Assigned = "NO"
  5. Delete rows where Catalog Sort Order is less than or equal to 999
  6. Save as Data_CR2.xlxs