• Find and Replaced texts in Column D (Purchases in past month) that contained strings ‘List:’ and ‘Typical:’ and deleted these entries.
• Formatted Column F (AVG Rating) to display the rating as just the first 3 characters by using the =LEFT(Cell, X) formula. For example instead of ‘4.5 out of 5 stars’ it now displays ’4.5’.
• In column E (Purchases in Past Month) removed all characters after “+” symbol (ex: 50+ bought in past month) to simplify the data given in this column.
  • =LEFT(E21, FIND("+", E2) - 1)
• Any numerical entries left blank had a “0” inputted in order for MySQL to properly import the data.
• Added a new column “ID” so each row has a unique identifier.