Preppin' Data

We need to talk about Dave... he's a good salesman but he's not our analysts' best friend. Dave is "too busy" to consistently enter his data. He likes to sometimes hit CAPS LOCK. Does Dave even know the shift key exists? Our challenge this week is to tidy up the messy data Dave has left behind him by creating a nice data set so we can analyse his sales, favourite customers etc. Requirements Input Data Bring in all tabs of the Excel Sheet Create the date of the sale Create a column for the scent of the product Create a column for the product Create a column for the customer name - with the customer's name in Title Case  Output One file 6 columns of data 18 rows of data (19 rows including headers) No nulls For comparison,  here's our output files .  Don't to forget to fill in our  participation tracker !