Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEATurned the upper part into a macro to test the 2nd time
I took a different approach here and decided to show both the solution directly as well as the "macrotized" solution. Also, you will see some union tool magic every so often. Enjoy!
Dynamically adds and names any number of columns
#151 - dynamic rename using right input rows to maintain order.