Hi,

I am spearheading a data collection project that is requesting data from a lot of different resources.  I've explained to all the sources what I need in the CSV file (here's the shortened version):

Field1 Text 10
Field2 Text 10
Field3 Text 10

And a good majority of the data comes back in the expected fashion:

1234567890,1234567890,1234567890
0987654321,0987654321,0987654321

However, there are a few of them that send the data back in this format:

Field1,1234567890
Field2,1234567890
Field3,1234567890
Field1,0987654321
Field2,0987654321
Field3,0987654321

How can I transform the data above to the correct format?  Since I'm new to Talend, I think I'm trying to find a single step to transform the data.  Is this possible or do I need more than one step?

Any help would be greatly appreciated.

Thanks,
-Greg