Preppin' Data

Solution by: Rosh Khan  You can download the workbook from here Step 1- Input Data  As with all challenges, the data can be downloaded from the challenge requirements. As we are working with Excel files, we can choose Microsoft Excel as our connection type. Step 2 - Split the field ‘Name’ into Game Title and Developer We know that the field ‘Name’ contains two pieces of information: Game Title and Developer, and therefore needs to be separated. The characters separating the two in this case are “ (made by “ , therefore, we can click on More Options under the field ‘Name’ -> Split Value -> Custom Split -> and define our separator to be “ (made by “  and Split off the first 2 fields. Please note: There is a space before ‘)‘ and after ‘by’ After applying the following formatting: Change field names to be ‘Game Title’ and ‘Developer’ Removing trailing and leading spaces from both fields Removing punctuation from the ‘Developer’ field (More Options -> Clean -> R...