Slightly different answers than the ones provided for question 1, and using Double instead of Fixed Decimal leads to a different result in question 2, but we're gonna just go with it because my logic feels sound. 🙂
Interesting challenge, I took a different approach to most (any maybe over-used the transpose and cross tab tools!).
I found the wording of this challenge a little harder to understand compared to the others as well.
However I managed to come up with a solution that's slightly different to the given output 🙂