You can try using tNormalize component along with tMap component. It worked for me. Below is the screenshot of my Job and the expressions I used for the transformation of the columns.
To perform this, add and link the components as shown below:
Once you are done setting up the components, go to the tMap component and concatenate your rows and columns with a semi-colon (;), as shown below:
Finally, normalize the data, to get the desired input.
Hope this helps!
To know more about Talend, join Talend for big data certification training today.