Thanks for the reply ErnestoM. For some reason I can't attach the XSN.
Yes, I merged the data using eval function in a separate field then submitted to form library as the XML.
First, I tried to use merge function while promoting fields. Even in this method also, I got merged data only as single column in the repeating table.