Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEADo not know how to deal with it initially, Good practice
Here is my solution...
The employment category and category though don't match the desired output since I don't have carriage returns...
Also, the final result does not contain the same record count since the source file has probably changed since this challenge was put in place...
This one was fun!
Quite messy and a lot of investigation of the data was required but got there in the end! My solution.