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

Regex saves the day once again!

We've all worked with a dataset like this out in the wild 😛

My solution for challenge #188

Screenshot 2020-09-19 122938.png

regex to the rescue:

Here's my solution:

My solution.

Carried the VAT number down, then filtered to the header and value rows. Marked delimiters, parsed, then replaced field names with the header row. The rest was formatting with Multi-Column and sorting.

Carried the VAT number down, then filtered to the header and value rows. Marked delimiters, parsed, then replaced field names with the header row. The rest was formatting with Multi-Column and sorting.

Good practice for advanced exam - but painful!