Search

Close

Start 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

Solved in two different ways (with JSON Parse and with Text To Columns).

This one was really fun.

Screenshot 2023-10-27 141756.png

PFA my solution

Solution attached

1. double parse the json

2. A combination of transpose and crosstab

3. Clean the data when required

Here's my solution

Tried to be more compact, but I'd like the JSON parsing tool to be more specific.

This challenge is fun and a bit difficult.

Great to play with the JSON format!

Screenshot 2023-11-01 184807.png

Live Weekly Challenge