It's my first time submitting an answer and the first time using Alteryx. The magic happens on the formula step.
I also can't use the vertical layout as I don't find them compact enough to fit one screen wherever possible. And if a function to pick the nth lastest value would exist, my solution would be more elegant, in my opinion.
Thank you for the challenge, @Kenda.
Don't know whether its the right way but used Generate Rows Tool to get the desired combination output. Anyways the best part, got to learn about the tool.
Thanks & Regards,