Problem with property transfer

I am new to soapUI Pro, so I am not sure if I understand everything. I created a test suite to test a web service to add a record to a database. Here are my steps:

1. Read data from an Excel file.
2. Transfer data read from step 1 to a request in step 3.
3. A request to add a record.
4. Loop back until running out of data.

Let's say that I have two fields in the input Excel file for fields call field1 and field2. In the Excel file, I have the data like this:

Colum1      Column2
A                B
C
                  D

The first time when step 3 is executed, a record is added fine. Then, it loops for the second time and a request is submitted again fine. However, when it loops again to submit data for field1 and field2, step 2 fails and I saw an error saying "Error performing transfer..." and it indicates that the problem is because the element for field2 is not found. I suspect that this happens because when the request was previously submitted, field2 was set to be empty and somehow after the request is submitted, the element for field2 disappeared (I did not see when I viewed the request in XML). How can prevent this from happenning. I don't want empty elements to be deleted from the request so that I can keep feeding the data to all fields in the request.

Am I missing something here? I would appreciate if anyone can provide me with a way to work around this problem.

Thanks,

RJ