Disorganized data can be cleaned by using the regular expressions tool to divide crowded columns. The Join Tool was also used with a Candidate ID to join tables. With the absence of a unique ID a cascading “Not Found” is necessary. Following and ID join, First-Last-Company becomes a 2nd join, then by email become the 3rd join. This maximizes the match of candidates.