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

svenk
8 - Asteroid

My Solution!

EFran
7 - Meteor

Took several approaches at this. I think this one is the most elegant.

neilgallen
12 - Quasar

attached! 

Ukashi
8 - Asteroid

Thank for the challenge - I needed to wrap my head around those cross tabs and transpositions for a while - but over all good excercise.

 

Spoiler
image.png
MattKing
8 - Asteroid

 

Hi, here is my solution

danilang
19 - Altair
19 - Altair

Tricky...having to split the records.  Good one

Laurap1228
11 - Bolide

Find my solution attached :)

justynam
8 - Asteroid

My solution attached

justin_winter
8 - Asteroid

Pretty straight forward and fun!

 

cmfelton
6 - Meteoroid

My solution assumes that there is a 1:1 match between Product, Type, and Market.