by Wyn Hopkins

The Challenge: Survey Response

• Remove any current AND FUTURE columns that begin with Sys, but allow for other future additional (non Sys) columns to be automatically included
• Replace all but 1 space between the names in the first column
• Add a TRUE / FALSE flag for the 3 response options in 3 separate columns (there will only ever be a maximum of 3 answers)

And here’s how we did it…

Thanks for all the submissions, a record number so far from all the challenges we’ve posted. If you would like to check out some of the answers here they are:

June 2022 Power Query Challenge Submissions