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

Here is my solution:

just write the column names to a reference table should be more efficient, but I challenged myself the parse the column names out, that's when the headache started, anyway, even the workflow is really not elegant, I managed to get the column names out.

Here's my take on the matter

Want to see the batch workflow where all the magic happens?

209 batch.jpg

such a good brain teaser for the week...

output:

I created a batch macro to extract data, done!

My Solution.

I could have made it better, I guess.

This was really fun. Here's my solution, I put some comments in order to make it more understandable.

Busy week so I didn't have a lot of time to play with this. Here's a quick and dirty solution