Here is my entry to the challenge. Thanks for posting these. It really is making me think and go through the tools. Coming from Microsoft BI world it feels really odd to me not having a simple 'Derived Column' type transform to make expressions. I used multiple Multi-field Formula transforms to achieve this.
Edit- I now have gone through the solution and I see more intuitive way to solve this.