Weekly Challenges

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 #49: Reformatting Transactional Data

BrendaS
8 - Asteroid

Last one for today.

derekbelyea
12 - Quasar
Spoiler
2017-12-28_143415.png
blairmbailey
8 - Asteroid

Solution attached - thanks!

JoshKushner
12 - Quasar

Nice simple one

JosephSerpis
17 - Castor
17 - Castor

Challenge Completed

TeePee
8 - Asteroid
Spoiler
I found this challenge super tricky and ended up getting the final result with a convoluted hack of a workflow.  Clearly, I need more Crosstab practice!
Ozzy_Campos
8 - Asteroid

Took me a while, spent a lot of time trying to get it to work correctly.  But good exercise for practicing Transpose/crosstab.  

Elena_Caric
8 - Asteroid

Flipping tables like pancakes, it was a fun challenge! :)

CHarrison
8 - Asteroid

Always have trouble wrapping my brain around pivot tools, it's always good to practise them :) 

DriveMyData
7 - Meteor
Spoiler
Week 49.PNG