Challenge #64: Catch Me If You Can

[estherb47]

Fun one!! Needed only a few tools to accomplish, and I left the county names in. Dynamic tools are wonderful

Spoiler

Spoiler

[mceleavey]

And another...

Spoiler

I began by creating the titles from the "Fields" input, which is a combination of the Category, Subcategory and Description, I then used Dynamic Rename to take the new column from the Fields input and replace the Name column from the data. I then used Dynamic Select to to remove the non-title fields.

[LordNeilLord]

Great use case for the Dynamic tools!

Spoiler

[jamielaird]

Here's my solution.  Not sure why the posted solution doesn't include a location field (seems important!) so I've kept that in.

Spoiler

[nick_ceneviva]

Solution Attached!  Had never used dynamic select before.

[samN]

Spoiler

Created a long workflow only to realize that crosstab alphabetizes columns and then realized that a dynamic rename and select make it pretty simple.

Another one down

[ggruccio]

Another use case for transpose and crosstab

[LandonG]

Solution attached.

[PhilipMannering]

Definitely not the best. Looks like everyone nailed it with a dynamic select. Solution attached.

Spoiler

[jasperlch]

Solution attached.