Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAGonna go out on a limb and say this wasn't the most efficient solution.
WOW
This one kicked my butt.
1. I didn't know what a 'running average' was to begin with, I need to go back to math school.
2. The strange acronyms for column names made it difficult to understand what was going on when transposing data.
For a workaround for myself, I renamed the columns with actual words (car brands and some sciency sounding words), and threw in some color-coded table graphics to help me make sense of what the Transpose and Cross Tab tools were doing.
Nick