Challenge #112: Organizing Survey Data

[petgrap]

Spoiler

Spoiler

[AdityaSardeshpande]

My First Weekly Challenge. I tried using the MultiField Formula with Regex but, being completely new to Regex it was taking a lot of time.

So I moved on to a different approach. Here I got stuck at how to loop the Text to Column tool for several columns and spent quite some time trying to create a macro.

Finally, i just randomly tried the Summarize tool and got it working. This was fun and I will try to contribute regularly.

Great way to learn new stuff !!

-Aditya S

[yalmar_m]

My solution, though I agree that it isnt the shortest.

[mmongeon]

Here is my solution.

Spoiler

Could have been a bit shorter if I had used a Record Id instead of the New Column names, especially since I ended up renaming my columns to get rid of the underscore characters...
But overall I feel this is a pretty optimal solution

[FameAsser]

My first ever attempt at one of these - I am a very basic user but I enjoyed this one

Spoiler

Would greatly appreciate any feedback on this from anyone

[GalynaSkamrova]

My version:

Spoiler

[GalynaSkamrova]

My version:

Spoiler

[terry10]

I stubbornly didn't want to manually rename columns in select boxes, so I learned to use the SWITCH function and some other data manipulations to generate the column headers. 

[jamielaird]

Here's my solution. I'm sure it can be done in fewer tools but I quite enjoyed being in the "flow" of solving this one and ended up dragging in tools like a crazy person.

Spoiler