Data Transformation [Rows to Columns and Columns to Rows]

[amrzahran]

Hello everyone,

I am pretty new to Knime and I am trying to achieve something which I assume is possible with Knime but unfortunately I have been struggling for long now.

I have an input excel file in the following format:

And I would like to transform it to the following format:

Would you please guide me on how to achieve that?

Thanks a lot.

Attached to the topic are the input and output files shown above in the screenshots.
Input.xlsx (9.4 KB)
Output.xlsx (9.6 KB)

[izaychik63]

Use

Transpose — NodePit

node.

[amrzahran]

Thanks for your reply but unfortunately due to the original data structure a transpose will not give the required output.

[HansS]

Hi @amrzahran

Indeed the solution use the Transpose node. But the structure of the input file is a little bit complex. So I used the Chunk Loop .

and do some “stuff” along the workflow to get the column names and positions as in the output file.
Hope this helps.
data_transform_xls.knwf (65.7 KB)

gr Hans

[amrzahran]

Works perfectly. I am going through the nodes one by one to understand the manipulation in details.

Thanks a lot for your time