Challenge #154: Permute the Data

[jamielaird]

Here's my solution

Spoiler

[bmarx112]

A quick brute force approach

[LordNeilLord]

17

Spoiler

[anaibeth]

Here's my solution for this, took me longer than expected.

[Vidya26]

My Solution!!!

[piotrzawistowski]

My version.

[RWvanLeeuwen]

Pretty difficult, but a great opportunity to learn some more from others.

Here's my take

Spoiler

[alex]

Solution attached can work for up to 9 different switch positions.  Attached workflow has 5 options and 4 switch positions. 4^5=1,024 rows with all the possible combinations.  Tested to ensure no duplicates and correct number of rows.

Spoiler

[TimothyManning]

Spoiler

Took me a while to figure out in my head how to do it, but the crosstab was the key! Good challenge

[fmeo]

Spoiler