Challenge #50: Preparing Survey Data

[Erin]

This seems kind of weird to me, but I guess it worked out. 

[lwolfie]

Solution

[Tgigs]

Not a fan of this challenge, data did not make sense. Age in the data file does not match with age in the questions file based on the column field value. Some inconsistencies that are not easily reconcilable.

[hlombemalandela]

I just completed the challange here is my solution

[katejoyce87]

:)

[RasmusFormo]

[Rob-Silk]

My solution below - I tried to keep the question data column selection and renaming dynamic and added an additional challenge of splitting out the upper and lower bounds of the age ranges

Spoiler

[RashedDS]

Always make it simple.

 

[snbandi]

My solution - again getting better each day with Transpose/Crosstab tools(my main weakness) for Core Exam preparation.

[abbyabbypoon]

Spoiler