Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThis one is fun...and sort of hits home. Since I have been doing these, I have been getting more confident with the tool and my own ideas.
Here its my solution.
This challenge was interesting; my first approach was similar to most, but I changed course and transposed all at once; however, this solution would not be scalable in case more header rows are added; this is why I like @PhilipMannering 's solution using regex and Output Checker macro!