Challenge #447: Analysis of Survey Results Delivered in a Consolidated Format

[samgiroux]

I noticed that there were 5 instances where the row was marked "complete," but the respondent did not answer any questions.  So, I removed that from my data set, so my summary totals in Q2 were a little different.  Also, my data set included a usage response of "One year or more" that was not included in the solution.  Hmmm..... 

But, I loved the challenge to separate the questions from the answers.  Great challenge!!!

Spoiler

[samgiroux]

I agree!  That random (-) in the answer was a fun challenge.  I also noticed that there were some responses marked "complete" but still had no questions answered.  So, I had to remove those as well.  Super fun.

[ggruccio]

Fun challenge!!!

Spoiler

[logdog0411]

Spoiler

 

[alexnajm]

Tried the RegEx way originally but got lazy 😂

Spoiler

[BransonJamesFarley]

Fun Challenge! 

Spoiler

 

[sknman92]

my solution

Spoiler

 

[RashedDS]

First, I prepared the data in an arranged table, and then I got the task solutions from the table. 😁 

Spoiler

 

[AaronSmatta]

Challenging, but fun

[ARussell34]

Task are all complete!

Spoiler