Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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