How to change Excel Layout

Hello everyone. I am working on a project for aumatising the ordering process of a chain of stores using Knime. However it has been couple of days that I am trying to figure out how to change the layout of an excel file using Knime from table 1 to table 2 as shown in the Excel Attached:
Knime LAyout.xlsx (10.1 KB)
I would appreciate your help!
Have a wonderful day

Hi @mehdi_zinbi welcome to the forum!. You can use the unpivot node plus a couple of nodes to sort, create names etc. If you want to put borders and “style” your sheet you have the Continental nodes.

How to change Excel Layout.knwf (32.2 KB)


@iperez works perfect. Thank you very much, much appreciated!


This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.