Data cleanup with the formula tool

You have been hired as an HR analyst for a consulting firm named Genesis. You have been assigned to help with ad hoc reporting questions from various managers in the department.

The data you are analyzing has some cleanliness issues. There are multiple spellings for a given value, extra whitespace, and a missing enrichment column. Let's address these issues first so we can dig into our analysis!