Spreadsheet loader skips first creator role

[sarahjeansweeney]

I've encountered an issue with the metadata in spreadsheet load for the 300+ RISE posters. For each load I've submitted the first creator role is skipped and the second role is applied to the first creator name, the third creator role is applied to the second creator name, and the third creator name doesn't get a role at all.

So submitting:

Creator 1 Name - Primary Creator	Creator 1 Name Type	Creator 1 Role	Creator 2 Name	Creator 2 Name Type	Creator 2 Role	Creator 3 Name	Creator 3 Name Type	Creator 3 Role
Abourezk|Alya	Personal	Illustrator	Loring|Ralph	Personal	Researcher	someone|else	Personal	Advisor

Generates this:

 <mods:name type="personal" usage="primary">
        <mods:namePart type="given">Alya</mods:namePart>
        <mods:namePart type="family">Abourezk</mods:namePart>
        <mods:namePart/>
        <mods:role>
            <mods:roleTerm authority="marcrelator" authorityURI="http://id.loc.gov/vocabulary/relators" type="text">Researcher</mods:roleTerm>
        </mods:role>
    </mods:name>
    <mods:name type="personal">
        <mods:namePart type="given">Ralph</mods:namePart>
        <mods:namePart type="family">Loring</mods:namePart>
        <mods:namePart/>
        <mods:role>
            <mods:roleTerm authority="marcrelator" authorityURI="http://id.loc.gov/vocabulary/relators" type="text">Advisor</mods:roleTerm>
        </mods:role>
    </mods:name>
    <mods:name type="personal">
        <mods:namePart type="given">else</mods:namePart>
        <mods:namePart type="family">someone</mods:namePart>
        <mods:namePart/>
    </mods:name>

It's possible there's an issue with how I've constructed the spreadsheet, but I've tried a dozen or so edits without any luck (hence the dummy values in the table above). The spreadsheet validates, so there aren't any obvious issues with the spreadsheet itself, and the loader is reading the role values since they're being added to the XML for second and third creator names. I'm just not sure why the first creator role isn't being read or accepted or why the roles are being shifted to other creator names.