My solution, but my results do not match the Output file provided which has the "Vision - %" Powers included in the Measurements instead of as Powers. Reading the brief, I chose to leave my results with "Vision - %" as Powers:
So all the measurement columns are numeric and are grouped together except for Vision, which is categorical and scattered among the powers. Funny that a challenge about super-heroes turns out to be typical of the real world. How often do you get written specifications for a project that don't account for special cases or unexpected interpretations? That's why sample outputs help (although they still don't always include all the special cases).