My first take on solution is attached. I've been successful in analyzing workflows by writing out steps in English and then finding ways to streamline. However, I just did this one quick while I was waiting for my cube to finish.
I agree that the issue with the crosstab changing the column name by adding spaces is disappointing. However, I'm enjoying the tool very much.