[mattewong]

< Technical details about the data wrangling happy to share in comments if anyone's interested in that nightmare.

I'm interested. That is the nightmare my company obsesses about solving

[hermitcrab]

Do you mean solve - as in sort out your own mess?

Or solve - as in make a tool to sort out everyone else's mess?

If it is the former, have you looked at data wrangling tools, like Easy Data Transform (our product), Tableau Prep or Alteryx?