Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThe Make Columns tool definitely made this easier.
Once I understood the logic needed, the workflow was easy. No great surprise that my solution matches @NicoleJohnson - we often think alike on these :)
I took heavy inspiration from @NicoleJohnson's method on this one and learned some new tools in the process. Thanks! :)
Probably not the best solution for this one and will definitely look for the iterative macro solution as I used a batch macro solution. Great challenge!
Nice challenge. I started down the same route as @NicoleJohnson but split and then used a join to pull the streams back together
Dan