how to invert columns into rows

[Anonymous]

Bonjour, 

I have an excel file with 60 columns and 2 lines ... (first line correspond to column header and second line to value of column).

I'd like to convert columns into rows ... and to have 2 columns with 60 lines ... 

any idea ?

regards

Damien

[TRF]

You can try with tUnpivotRow component from Talend Exchange or with the standard tSplitRow.