Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThis could be done with a Batch Macro in case of more tables, but who knows what format they would be in. This solution should deal with the case where headers are 2 or 3 rows and any amount of data...
#262
There's still a bunch of hard-code, but could be nice to try the solution on a different data set to see how it generalises.
I'm new to RegEx so I'm sure my expressions are something of a train wreck, but in any case using this method gets the job done in only 9 tools (undynamically!)