Iterative Pony Permutations

[keith_wonghy]

Hi all,

Expanding on the Pony Permutations challenge,

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-270-Pony-Permutations/td-p/766962

I'm trying to build an iterative macro that generates every possible combination of race finishes for not just one race but a list of races (in some races, there may also be less than 4 horses competing):

I have not been successful so far, would really appreciate if someone can show me how. I'm not able to upload my files here due to policy restrictions (I'm using a company laptop)

Input:

	Horse1	Horse2	Horse3	Horse4
Race 1	Sally	Elmer	Sally	Mr. Ed
Race 2	Bojack	Roger
Race 3	Pegasus	Troy	Drogon
Race 4	Queena	Spirit	Donkey	Maximus

This is the result that i'm looking to have:

	First	Second	Third	Fourth
Race 1	Sally	Elmer	Sally	Mr. Ed
Race 1	Sally	Elmer	Mr. Ed	Sally
Race 1	Sally	Sally	Elmer	Mr. Ed
Race 1	Sally	Sally	Mr. Ed	Elmer
Race 1	Sally	Mr. Ed	Elmer	Sally
…	…	…	…	…
Race 2	Bojack	Roger
Race 2	Roger	Bojack
Race 3	Pegasus	Troy	Drogon
...	...	...	...	...

[Christina_H]

This was a fun challenge.  I think this should still work if you increase the number of horses in a race.