Transform columns into rows

[Anonymous]

Hello, i am beginner on talend, please could you help me with below query. 

I want to duplicate each row of my table 12 times, because I want to include a "month" column in the table, plus another “order” column that will contain the values ​​of the columns "month" of my source file. My input will be from excel file.

Extracted from the source file:

Id_cust	January	February
aaa	20	24
bbb	10	36

Output :

Month	Id_cus	order
January	aa	20
January	bb	10
February	aa	24
February	bb	36

Thanks.

[Anonymous]

Hello,

Could you please let us know if this related topic helps?

https://community.talend.com/t5/Design-and-Development/Transpose-Columns-to-Rows/td-p/40077

Best regards

Sabrina

[Anonymous]

Thank you @xdshi  for the link.

I found the solution with the component "tUnpivotRow" via the link that you sent me.

But I have a problem , when  I download the component in Talend 7.1, I get a msg “your selection will nest folders” and I can not find the component in the palette:

Thanks