Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThis one was tough for me! I learned a few new things though, like \n in the text-to-columns tool! Great challenge!
Solution attached. My results are slightly different than the desired output, as that file eliminates secondary specialties. I left the secondary in with a semicolon separating in the event that it should be filtered out.