Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA@CatheyH Regex101.com is a great resource
I went for as dynamic an approach as I could, although it might be over-engineered.
Tried to complete without Regex. Cheated a little by pulling the column names from the solution for the dynamic rename.
Here is my solution!