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 #63: Data Preperation Using Pivot Tools

PrivateStorm
8 - Asteroid

My solution to challenge #63 is attached.

catherineduffy
8 - Asteroid

My solution - I originally had the date at the start of the week as 'Week of', which makes more sense to me, and in reality I would probably leave the nulls rather than converting them to 0s in this context.

OldDogNewTricks
10 - Fireball

I'll have to review the other solutions, I had to use a lot of tools.

 

Spoiler
challenge_63_completed.jpg
JoBen
11 - Bolide

Cheers!

pasccout
8 - Asteroid

Here is my solution...

Laurap1228
11 - Bolide

Not the most elegant solution, but it works!

Spoiler
challenge63.PNG
WillTravelForData
8 - Asteroid

My first take on solution is attached.  I've been successful in analyzing workflows by writing out steps in English and then finding ways to streamline.  However, I just did this one quick while I was waiting for my cube to finish.    

 

I agree that the issue with the crosstab changing the column name by adding spaces is disappointing.  However, I'm enjoying the tool very much.

MarMu
8 - Asteroid

 

Always fun with some real life cases

I challenged myself and added a few more steps to circumvent the Cross tab header rename bug. It made the workflow a bit less slick though.

 

Spoiler
challenge_63_start_file_MarMu.png
Wouter
8 - Asteroid

My solution:

Spoiler
challenge 63.jpg
justynam
8 - Asteroid

My solution - I prepared macro to iterate through columns (not rows)