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 #112: Organizing Survey Data

papalow
8 - Asteroid

Love the reference to Napoleon Dynamite.  Here is my solution.

nini
8 - Asteroid

My Solution:

manuelam
6 - Meteoroid

2 solutions: one with Regex, one without.

KlaraKeutel
6 - Meteoroid
Spoiler
spoiler_challenge112.png
ipeng
8 - Asteroid

my solution

Adara
8 - Asteroid

Here's my attempt. Next go around I will have to try out some new tools I saw others use.

 

Spoiler
Capture.PNG
AidanBramel
8 - Asteroid
Spoiler
I imagine there's an significantly easier way to the the transpose/cross tab here, but this is what I ended up with :)
challenge 112.PNG

bhauteshved
7 - Meteor

I tried carrying out the solution you attached. but it outputs only 19 records instead of 26. It skips the records with leading and trailing whitespaces. Any suggestions. 

 

I'll attach the macro file in another post. 

hbraunius
8 - Asteroid

My solution attached.

Kenda
16 - Nebula
16 - Nebula
Spoiler
Capture.PNG