Challenge #154: Permute the Data

[DaisukeTsuchiya]

Spoiler

 

[Qiu]

Spoiler

[Watermark]

Completely dynamic for as many answers as you want no modifications needed. 

Currently set up for 5 'options/columns', only need to add 1 simple copy paste formula for each additional above 5.

Spoiler

 

[leozhang2work]

Spoiler

[ARussell34]

Append, Append, Append!

[TonyAndriani]

Reposting under my new user ID.

[dbAlfa]

Below my solutions with 3 tools and 2 possible values for each tool..

[binuacs]

solution attached

[mmontgomery]

Challenge #154

[scoles0617]

My solution: