I'm not sure if this is better suited in the programming related forum, but I'll start here.

An Excel spreadsheet I have is mapped to a XML file which essentially creates a XML file of the answers to a survey which are used elsewhere.

In this survey it is possible for a person to have an account but not reply to the survey and the answers are all blank. I need to export to the XML with account information but if they didn't reply to the survey, I don't want to export the blank result to the XML file. (Example below)

What is that I currently have this sort of Excel data. The last 9 digits are survey responses.
1 Doe 2009 05 1 8 5 6 8 3 6 2 9
2 Smith 2009 05
3 Brown 2009 05 3 5 6 7 8 9 4 5 6
4 Lim 2009 05
5 Jackson 2009 05 6 7 8 3 4 2 7 8 0
This exports as:
<account>
<id>1</id>
<name>Doe</name>
<year>2009</year>
<month>05</month>
</account>
<results>
<q1>1</q1>
<q2>8</q2>
... etc
<q9>9</q9>
</results>
If there were no responses to the survey, the result is
<results>
<q1 />
<q2 />
... etc
<q9 />
</results>
I would like to NOT export the results with no responses, but still export the account information. Is this possible or will this require some programming?

Any help is appreciated.