Challenge #49: Reformatting Transactional Data

[Ladarthure]

My solution

[KirstyHarvey]

Still trying to get my head around Transpose!!

[MikeLR]

Spoiler

[Harkamal]

here is my solution!

[Soura]

My solution

[jfeldkamp123]

Fairly simple flow here, good practice for transform and crosstab tools....

Spoiler

Split the first three rows makes it super easy!

[RahulSharma]

Solved

[troyeb4]

This was a great Transpose workout! A little different than the solution but works.

Spoiler

Spoiler

[omercado05]

I really liked this as I try to get more comfortable with the Crosstab/Transpose tools. My solution is similar to most, but I like the slight deviations seen here.

[mag161]

I originally did the cross tab after the join but saw that it was harder to keep up with all of the information. So I changed it to where I only used a crosstab for the first three lines after transposing, like many of the solutions. Really just an aesthetic step.