Excel BI Publisher Template: Reference a Specific Value

My XML data looks like this - the field VENDOR_ID appears twice.

<?xml version="1.0"?>

<rs_DDCPV009_H_TMP>

 <row_DDCPV009_H_TMP rownumber="1">

  <fld_VENDOR_ID/>

  <rs_DDCPV009_D_TMP>

   <row_DDCPV009_D_TMP rownumber="1">

    <fld_BUSINESS_UNIT>TOGE1</fld_BUSINESS_UNIT>

    <fld_REQ_ID>0000209717</fld_REQ_ID>

    <fld_VENDOR_ID>0000007211</fld_VENDOR_ID>

   </row_DDCPV009_D_TMP>

   </row_DDCPV009_D_TMP>

  </rs_DDCPV009_D_TMP>

 </row_DDCPV009_H_TMP>

</rs_DDCPV009_H_TMP>

VENDOR_ID appears twice.

If i reference it in an EXCEL bi publisher template and drag and drop the header VENDOR_ID field to a cell, it repeats the value (every vendor field) concatenated.