Went for brute force method as well. Was think setup a macro to generate rows, but I found it is easier just to do copy & paste as answer workflow did. Added filter just to reduce output rows.
Run under 1 minute with AMP engine.
Not a dynamic solution.
Most of the methods I tried were taking a long time to calc, based on brute force. After trying a Pandas Python frame I noticed someone else utilize, I had to go that route, a 5 second calc was just insane compared to the brute force methodology. Couldn't have gotten this without other contributors in the community.
Sometimes I think I'm getting good at Alteryx and then I end up doing a challenge with a brute force like this! In retrospect I obviously should have set positional conditions before running it through the macro.
