Xpath creating incorrect data

Hello,

I am trying to read a large XML of customer data. The issue is that there are several columns within the XML around 12. The KNIME is reading these as individual columns and just putting them next to each othere, where as i need them to be read as one customer.

The problem here is that if one piece of data is blank, instead of leaving it blank, it pushes the data up, so now the data is out of sync, for example where the data should look like this:

Customer

|Customer|Area|ID|

|—|—|—|—|—|

|Thomas|Sunderland|789|

|David| |123|

|John|Newcastle|485|

The data instead looks like this:

Customer

|Customer|Area|ID|

|—|—|—|—|—|

|Thomas|Sunderland|789|

|David|Newcastle|123|

|John| |485|

Can anyone help me resolve this issue?