XML Mapping Issues
 

I am fairly new to mapping XML into an excel spreadsheet, and I need some
help to make the spreadsheet behave the way I want.

I receive an xml file from an outside application that is in this format:

<?xml version"1.0"?
<Master
<Header
<HeaderInfo...</HeaderInfo
</Header
<Record
<Reference type="A"a1</Reference
<Reference type="B"b1</Reference
</Record
<Record
<Reference type="A"a2</Reference
</Record
<Record
<Reference type="A"a3</Reference
<Reference type="B"b3</Reference
</Record
</Master

Basically, there isn't always a Reference Type "B". I want to map these
into excel into two columns, like:

a1 b1
a2
a3 b3

What I did is set up two source maps, mapped one using type="A" into one
column, and type="B" into the other. Unfortunately, I get this:

a1 b1
a2 b3
a3

Is there a way to have the map pull a blank if there is no Type B entry,
instead of skipping over it? This is probably pretty rudimentary, but I
can't figure it out.
Thanks in advance for your help.