Map Multiple Elements in Excel

[wxdqz]

Hi, I'm trying to map a single element to multiple columns in Excel and I'm having a bit of trouble. For example, my schema looks like this:

<?xml version="1.0" encoding="utf-8" ?>
<schema xmlns="http://www.w3.org/2001/XMLSchema">
<element name="Root">
<complexType>
<sequence>
<element name="Distribution" maxOccurs="unbounded">
<complexType>
<sequence>
<element name="town" type="positiveInteger" />
<element name="species" type="positiveInteger" />
</sequence>
</complexType>
</element>
</sequence>
</complexType>
</element>
</schema>



and I want to map species to a bunch of columns... however, I get the message: This element is aleady mapped, an element cannot be mapped more than once.

I read somewhere that you have to change the ancestor element... but I'm not sure what to do. Can anyone help?

Thanks!