This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
I ignorantly didn't really understand the structure of xml and what the xml parse was really doing, so I only used one, and then tried to parse out the rest using regex and multirow formulas. I did think it must be easier (!) and so after finishing, I looked at the spoilers and used several xml parse tools as in the solution.