Work Flow

1.Remove the unnecessary columns. 2.Find and remove duplicate rows (records) or any rows that are completely blank. -Remove duplicate by going to Data Tab, Remove Duplicate 3.Find duplicate values for Case Number, and modify them.

4.Find blanks: a. Year column

• Filter by using Sort & Filter, then filter for blanks.
• use the first four characters of the Case Number as the year

b. Other Column

• Filter by using Sort & Filter, then filter for blanks.

• then replace blank with the word "unknown" for Type column

  

1. Use the Sort & Filter tool to make sure the dataset is cleaned properly.