Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy solution.
Wow!!! Very tough one. Lots of cleaning, tweaking and checking iterations to get it all straight. Makes me appreciate how clean my company's data is in a Data Warehouse structure.
Glad to see my general approach in the beginning aligned with the posted solution approach. However I did a lot more complex cleanup at the end so definently not as streamlined as the solution.
Also I think i populated 1 or 2 additional Notes Fields when compared to the solution.
Anyways....here it be......