Reshape a table in Knime

I am new to knime and want to reshape a table from long to wide format: I have a tavle like this:

Indicator Sex 1990 1991 1992 1993 1994
EMP F 10.31 10.41 10.51 10.61 10.71
UN F 10.71 10.81 10.91 11.01 11.11
EMP M 10.21 10.31 10.41 10.51 10.61
UN M 10.61 10.71 10.81 10.91 11.01

Want to reshape it to :

Year Sex EMP UN
1990 F 10.11 10.71
1991 F 10.21 10.81
1992 F 10.31 10.91
1993 F 10.41 11.01
1994 F 10.51 11.11
1990 M 10.21 10.31
1991 M 10.31 10.41
1992 M 10.41 10.51
1993 M 10.51 10.61
1994 M 10.61 10.71

 

I have tried pivoting and unpivoting the problem is I don't need any aggregation and it is not a complete tranpose either. Can you help me please:

 

 

Hi Yashar,

to achieve the desired wide to long transformation in KNIME you can use a combination of Unpivot and Pivot. See the attached workflow.

Cheers,
Marco.

this was a post fro while back I ended up using R (reshape) with a bit of modification