Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

my solution

Done

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

Solution as attached

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

Answer

My solution to 49:

Solved

Challenge #49: Reformatting Transactional Data