Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEACame to the same solution as everyone else. That said, I tried at first to use the Record ID tool and a second later knew that wasn't going to work. Still trying to get comfortable with the Multi-Row tool and I realize how powerful it really is. Appreciated the skills this challenge was trying to build up.
My solution
Another nice use of the tile tool. It's very useful as a grouped version of record id.
This really should have been easy but somehow it just wasn't.
I did not bother loading the new driver, just converted the files to .xlsx. And keep an eye out for the misleading numbering in the files