Open the spreadsheet below. The spreadsheet data is a list of roller derby players and points scored. Some of the players play on two teams. The goal of this exercise is to create a pivot table that combines scores across the two teams and reports total points scored by player. Deliberate introduction of white space erro$[$s causes excel to treat the same player's name as distinct individuals. $2.$ To see the problems caused by white space errors, use the initial data to create a pivot table that lists the players and the sum of their points scored. In some cases, Excel will treat the same player as unique between the teams due to the white space errors. We want to eliminate the white space errors so that the pivot table correctly combines player's scores.

Apply the techniques from Lectures $5$a and $b$ to determine which entries have white space errors, and then clean the data appropriately. Use your results to answer the following questions.