Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Lots of detailed data manipulations. I made the manipulations as flexible as possible thinking of design for future use if the input file changes (e.g. another demographic is added) and not hard-coding record IDs. A little tough to make flexible for the first lines and using dynamic rename to convert first row of data to field/column names as it has to be precise. As usual, not completely happy with my solution. Funny that when I open my solution, it shows errors (!), yet it runs fine. Haha!
My solution
Here's my solution: