Challenge #49: Reformatting Transactional Data

[Powerhouse_21]

Spoiler

[CMWalsh]

Got very stuck on this, but managed eventually...

Spoiler

[Brian32]

Challenge Solution:

Spoiler

[KalpanaM]

[lkim524]

not very efficient but it does the job...

[Abiramm1]

I came up with a very dynamic solution for this one (quite chuffed) :)

Spoiler

[aplenos]

Spoiler

EASY! :D

[eslamahmed1111]

solution

[sbui7]

Spoiler

Need to practice using cross tab and transpose!

[Reesetrain2]

All,

Spoiler

My solution:

I used the same process four times as there may have been a better way to accomplish.