Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語

IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge Completed

dang, this one turned out to be wayyy easier than it looks at first glance. PRAISE THE DYNAMIC TOOLS! :-)

My solution :)

Not entirely sure of this one. Some column names are missing, but I see other people are just igonring those not matching?

Follow my solution file attached...

I looove the dynamic tools. Managed to do this one pretty quickly :)

Whew, that wasn't as scary as I orignally thought!

I spent some time building an elaborate column naming scheme that would survive the crosstab tool, but stumbled upon a reference to the dynamic rename tool! It chopped the length of my workflow in half

Solution 64.png

Dan

Challenge #64.PNG