transpose columns

[ravi13]

Dear Knime Enthusiastic!!

Hope you are doing well.

I am facing below problem in knime while using transpose node.

From Input format, i want into output format.

while using transpose, i am getting below output.

Am I doing something wrong ?

Thanks in advance!!

[ScottF]

I think you actually want the Unpivoting node here. Retain the department and designation columns, and make the various role assigned columns your values.