Challenge #49: Reformatting Transactional Data

[RNG]

.

[PhilBalderson]

Back to back transform and cross tab still blows my mind! 

[CHerv]

Good challenge ... took a while to play about with cross-tab & transpose.

Spoiler

[DemandEngineer]

Not sure my approach was the simplest... will compare to solution next.

[fimler]

Spoiler

Two slightly different (first step) solutions with the same result.

[Ross_Easton]

Solved, probably should have made a macro here

 

Spoiler

[gerizam]

Spoiler

[treepruner]

Pretty sure I am brute force here and not elegant in my solution...

[AkshayB]

Challenge_49_Solution

[ehughes]

My solution

Spoiler