Challenges: Final Friday Fix: April 2019 Challenge

On the final Friday of each month, we’re going to set an Excel challenge for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There’s no prizes at this stage, you’re playing for bragging rights only!

Extracting Text From a Column

Imagine you had raw data like this:

You need to make more sense of it so that section headings are associated with each code, viz.

The challenge is, how do you do it..?

Sound easy? Have a go. We’ll publish what we think is the best solution in Monday’s blog. Have a great weekend!