Challenge #49: Reformatting Transactional Data

[lapin_dangelau_24]

my solution

[akorte1]

Done

[richmondbound]

This transpose and cross tab work is something serious, how do you stay on top of it. Very mind bending.

[Daniel1127]

Solution as attached

[longyanChen]

HI

[Milly103]

I've got to the solution without using a join, but using IF formulas instead to rename the headings.

[Colintermeer]

Answer

[RobbieA]

My solution to 49:

[Shahbaz_analyst]

Spoiler

[Crispy131]

Solved