Wow... I can't believe that I actually managed to work this out. When reading through the question for the first time, I just stared at the screen with a blank expression on my face. Then bit-by-bit I managed to work out how to do it! Alteryx really is quite an intuitive software!
It's now time to see how others solved the challenge, before I move on!