Free Trial

Weekly Challenges

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

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

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

SUBMIT YOUR IDEA

Challenge #49: Reformatting Transactional Data

RebekaMazuchova
8 - Asteroid

:)

Dominic_Brady
8 - Asteroid

My solution

TGreen
8 - Asteroid

Solution attached.

dvaldez
7 - Meteor

I felt I was overcomplicating my approach, so I had to check the solution to this challenge. I really learned a lot from it. I replicated the proposed solution to practice and understand it better.

 

Thanks.

Jonathon-Sheppard
8 - Asteroid

The more practice I get with cross-tab and transpose, the better! They still befuddle me :-/

Daniel_Homola
8 - Asteroid

Here!

MMaske
8 - Asteroid
Spoiler
Screenshot 2025-05-18 163728.png
jaredcoffin
7 - Meteor

Breaking up headers and using the Dynamic Rename ending with a join, did it.

ollierossrussell
6 - Meteoroid

Here is my workflow for the week 49 challenge

Spoiler
Screenshot 2025-05-27 172104.png
kieranjoy
6 - Meteoroid
Spoiler
My Solution:
Spoiler
challenge49_flow.png