Challenge #64: Catch Me If You Can

[RolandSchubert]

My solution

[KeithTroutt]

I got a little tripped up on the sort order but finally got it. 

Spoiler

[RichoBsJ]

Hi! Here my solution :)

[acrahen]

My first attempt using brute force

Spoiler

Embarrassing my first attempt with a peek at some of the other answers

Spoiler

[cplewis90]

This was a bit tricky, but after looking through some new tools I was able to get there.

Spoiler

[Sajeel_Kershi]

originally had transpose and join to the header formula followed by crosstab which puts in extra "_" into the fields names. Was going to follow up with a dynamic rename to remove extra "_" when I got the realisation that I can cut out the entire transpose > Join > Crosstab part and go straight to Dynamic rename. The Dynamic Rename tools are awesome!

[Jonathan-Sherman]

Pretty quick! Used a RecordID key to ensure the columns outputted remained in the same order as the initial input.

Spoiler

[JonathanAllenby]

Here's my solution to challenge 64.

[johnemery]

Interesting challenge. I always try to make my workflows as simple and efficient as possible, so I'm pretty happy with this solution.

Spoiler

[hanykowska]

this seemed quite easy actually, don't know if I've cheated or not...