Preppin' Data

 Challenge by: Jenny Martin Have you ever been given a datasource to work with which has already been lovingly "cleaned" and turned into a pivot table? Whilst that's very kind of the provider, it's not exactly ideal for Tableau Desktop! Let's work to un-pivot such a table from a stakeholder at AllChains! Input A 145 (!) field pivot table: Requirements Input the data Dynamically rename the fields so that there is a common separator between the Bike Type, Date and Measure Name Pivot the data Split out the Bike Type, Date and Measure Name Create a field for Sales and Profit Output the data Output 5 fields Bike Type Region Month Sales Profit 288 rows (289 including headers) You can download the  full output here .  After you finish the challenge make sure to fill in the  participation tracker , then share your solution on Twitter using  #PreppinData  and tagging  @Datajedininja ,  @JennyMartinDS14  &  @TomProwse1 You can also post your s...