Preppin' Data

Challenge By: Jenny Martin Uh-oh, looks like the Sales Team at AllChains have gone rouge with their trackers again. They can't even maintain consistency month to month! And what's the idea with having the Salesperson names at the end of each month?  This challenge was inspired by a dataset my colleague Ollie  encountered, except that dataset didn't have a RowID. If you think of a way to solve this challenge without a RowID we'd love to hear about it! Inputs October Tracker: November Tracker: Requirements Input the data Fill in the Salesperson names for each row (the name appears at the bottom of each monthly grouping) hint Bring out the YTD information from the October tracker and use it to create YTD totals for November too Reshape the data so all the bike types are in a single column Output the data Output 5 fields Salesperson Date Bike Type Sales YTD Total 915 rows (916 including headers) You can download the  full output here .  After you finish the challenge mak...

Challenge By: Jenny Martin Secret Santa is a bit more difficult this year, without everyone being able to gather together and pick names out of a hat. Never fear though, we can randomly assign Secret Santas to their Secret Santees with the Power of Prep! Although we will simplify things a little so the assignments follow a logical rule rather than being completely random, but I'm sure our Secret Santas won't realise. After all, it's supposed to be secret! Input One input of the Secret Santa Participants and their email addresses:  Requirements Input the data Assign Secret Santas to Secret Santees that follow them in the alphabet i.e. Ellie should be the Secret Santa for Emma Since no one follows Tom alphabetically, his Secret Santee should be Ellie, as she is first alphabetically Some of the email addresses contain typos. Clean them up To make life easier, we're planning on automating sending the emails. Create a field for the Email Subject and a field for the Email Bod...