Start Free Trial

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

lukemorgan
8 - Asteroid

Here's my solution!

SamHD
8 - Asteroid

More fiddly than you think it is going to be! Made two solutions:
First attempt was crude and I thought there had to be a better way than this.
Second attempt was after I realised everybody was using the Transpose and Cross Tab tools I have yet to ever use. I spent a while fiddling with them and sort of have an understanding of them now!

Spoiler
SamHD_0-1760456859801.png

 

SWACorgizilla
6 - Meteoroid

Attached is my solution for challenge #49. :)