Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEALooks like a missed the mark a bit on this one. My solution was much more complex since I tried to use Transpose to link the column names with the concatenated file names. Was a good learning process.
My solution is below 🙂