Still cant upload images to the community but was able to solve this by pivoting and joining. A couple interesting tools - Multi-field formula and dynamic rename make an appearance!
Small gripe: The question does ask for a percentage but the answer suggests a decimal, watch out for that one!