Data Transformation from long to wide or reverse

KNIME Analytics Platform
1

Hi there, 

I am quite new to Knime. Have seen great things done in Knime. I am trying to use to to tranform a long dataset to wide. Something similar to Input1.xls

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

 

to something similar to input2.xls or

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

 

Could you help me ? I tried pivot but it does not do exactly what I am looking for ... I know how to do it in R or Stata I am just want to do it in Knime. 

2

Mark as duplicate see original post here

https://tech.knime.org/forum/knime-users/reshape-a-table-in-knime