We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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

ntakeda
11 - Bolide

My solution.

jay_char
8 - Asteroid

Good for practicing!

mrararaman
6 - Meteoroid

Salient points as per the approach taken here:

  • Keeping the column F1 common, select, pair & treat one value column at a time (amongst F2, F3, F4 & F5)
  • Creation of a macro (attached NewMacro1.yxmc) to treat one pair of columns at a time.
  • Usage of Union tool for stacking up the results

macro-vw-wkly-challenge-49.pngworkflow-vw-wkly-challenge-49.png

Thanks,

Ananth

mithily
8 - Asteroid

less elegant than the solution but it got the job done

Rob_1
6 - Meteoroid

My solution

CBarito
8 - Asteroid

🙂

CVCurcurato
8 - Asteroid

Great refresher on transpose and crosstab after not using it for a while!

dj-khaled-another-one.gif

JS1989
8 - Asteroid

Great challenge

josedlr00
8 - Asteroid

Good challenge, good practice for crosstab and Transpose tool

Sebastian_Chaieb2
8 - Asteroid

My solution

Spoiler
Capture.PNG