Challenge #112: Organizing Survey Data

[Jean-Balteryx]

Here is my solution !

[JeremyGonzva]

Got there in the end haah

[AndrewS]

#112

Spoiler

[dashakir1]

Thanks.

[Jonathan-Sherman]

Challenge 112 is done!

Spoiler

[EW]

This was fun! 

Spoiler

There's almost certainly got to be a way to handle the one record with a trailing space in the Regex tool, but it kept not working so I finally gave up and used data cleansing.  

[AngelosPachis]

Challenge #112 solved

Spoiler

[vghazaryan]

Followed Kat's steps up until the multi-field formula, where I altered the RegEx Replace with a simpler formula (Note*this will leave you with trailing spaces so added a data cleanser). 

[balajilolla]

Spoiler

Solution Attached

[Ladarthure]

my solution