Challenge #447: Analysis of Survey Results Delivered in a Consolidated Format

[aatalai]

C447

[Bobbyt23]

Fun challenge, lots of ways to do this, tried to keep it as simple as possible.

[sophiezero]

This is a good example to practice parse tools, also use multi-row formula.

Spoiler

[martinson]

Attempt 1

[Spainey]

Thanks for the fun challenge!

Spoiler

[Alfie_King1]

Spoiler

 

[TobiasFitschen]

Spoiler

 

[cdwaraga]

my solution

[cmoussa]

[3I_ATLAS]

labor intensive...

Spoiler