Challenge #112: Organizing Survey Data

[Spalders]

Spoiler

[WernerE]

Spoiler

[mikeprice17]

Could make it better but it is late.

[KilianL]

Great challenge for transpose, cross tab and splitting your data for a more dynamic solution.

As an Alteryx Sales Engineer, I aimed for a simple and dynamic solution, renaming only 3 columns manually.

Spoiler

steps:
1. take rows 3,6,9,11-14,16
2. record ID
3. transpose all, key as record ID
4. cross-tab, group by name, record ID as headers, value as value
5. clean up

[ReconBen]

Spoiler

 

[JP_SDAK]

I struggle with rather to determine column names dynamically, or just use SELECT tool and rename them that way.  I sort of did both here - so probably could have simplified and used less tools on the last 6 columns...

Spoiler

[ArnavS]

great example of reformatting data

[rcarog]

Solution attached.

[apathetichell]

I remember looking at this one before I understood the magic of the summarize tool and I had like all these tools on the canvas and couldn't get anything to work....

[mpennington]

Attached. Almost reworked the whole thing, as I felt I made it too complicated, but decided to leave it. Interesting use case for the Arrange tool, in my method, so I've got that going for me.

Spoiler