Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI need to study more time series.
My solution to the prix.
A bit simple because I am still learning the multi field and multi row tools
Pretty much the same solution as @NicoleJohnson - just used a different method of doing the initial cleanup. Sadly, not as fast as Nicole, started in the evening, and finished in the morning, so my stopwatch is over 10 hrs...
Seemed to work 🙂