We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
Weekly Challenge
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit Feedback
I was stuck until I peeked at some of the solutions and saw the text to columns tool could be used for text to rows as well. From there I just multi-rowed my way to a solution.
Went a different (and looonger road). Nested macros.
Spoiler
Main workflow
First Batch Macro
Inside Batch Macro
Main workflowFirst Batch MacroInside Batch Macro
