Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAWe've all worked with a dataset like this out in the wild 😛
regex to the rescue:
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!