title: How do I map XML sequences to Excel columns?
body: <p>I'm new to XML. What I have is a load of XML from Adobe Illustrator which I'm trying to map excel data onto. I have sequences in the original data which look like this</p>
  
  <pre><code>&lt;Market_Pie&gt;
  &lt;datanumDataColumns="5"&gt;
  &lt;values&gt;
  &lt;row&gt;
  &lt;valuekey="name"&gt;&lt;/value&gt;
  &lt;value&gt;503.931&lt;/value&gt;
  &lt;value&gt;268.301&lt;/value&gt;
  &lt;value&gt;285.561&lt;/value&gt;
  &lt;value&gt;152.037&lt;/value&gt;
  &lt;/row&gt;
  &lt;/values&gt;
  &lt;/data&gt;
  &lt;/Market_Pie&gt;
  </code></pre>
  
  <p>Excel has created an XML map from this which sees this as a single sequence. When I try to associate this with various cells, it seems to want to see this as a single column. My data, however, is structured so that this data needs to be in a series of separate columns, one column for each value. </p>
  
  <p>I'm using Excel 2007, and just can't see how this is supposed to work. The help files seem remarkably unhelpful as well.</p>