# Data transforming - **URL:** \ **Category:** KNIME Analytics Platform\ **Created:** [October 31, 2021, 7:34pm UTC](https://forum.knime.com/t/data-transforming/37060 "2021-10-31T19:34:50Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Vaze](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/v/a9a28c/32.png) [@Vaze](https://forum.knime.com/u/Vaze)\ **Post date:** [October 31, 2021, 7:34pm UTC](https://forum.knime.com/t/data-transforming/37060/1 "2021-10-31T19:34:51Z")
Dear all, I guess I have a very easy task but unfortunately I stuggel to get the data transformed like I need to. ![image](https://forum-cdn.knime.com/uploads/default/original/3X/7/a/7a1971184cf504441d49ca7e58e0810b764d6790.jpeg) The left hand side is the current data format and I want to get the data in the left hand Which data manipulation is needed? Thanks in advance and best regards, ---
**Author:** ![bruno29a](https://forum-cdn.knime.com/user_avatar/forum.knime.com/bruno29a/32/28802_2.png) [@bruno29a](https://forum.knime.com/u/bruno29a)\ **Post date:** [October 31, 2021, 8:45pm UTC](https://forum.knime.com/t/data-transforming/37060/2 "2021-10-31T20:45:14Z")
Hi @Vaze and welcome to the Knime Community. This would be a data manipulation involving Pivot. Input data (same as yours): ![image](https://forum-cdn.knime.com/uploads/default/original/3X/b/f/bf49642276eca084eace7174f7086c08a5e74adc.png) After pivoting: ![image](https://forum-cdn.knime.com/uploads/default/original/3X/3/4/3489f81a6455b44d31eaf9c237c76b29799472c6.png) Workflow looks like this: ![image](https://forum-cdn.knime.com/uploads/default/original/3X/e/5/e565b339e7e22642061a34fd5de91fe34fc047ee.png) And here’s the workflow: [Data transforming - vertical to horizontal.knwf](https://forum.knime.com/uploads/short-url/cxvlMxQVRLZz3gmqJMlb70gjDi2.knwf) (7.2 KB) ---
**Author:** ![Vaze](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/v/a9a28c/32.png) [@Vaze](https://forum.knime.com/u/Vaze)\ **Post date:** [October 31, 2021, 8:50pm UTC](https://forum.knime.com/t/data-transforming/37060/3 "2021-10-31T20:50:28Z")
Thanks for that! But how can I integrate my xls file into the Table Creator? Sorry for the stupid questions Best regards ---
**Author:** ![bruno29a](https://forum-cdn.knime.com/user_avatar/forum.knime.com/bruno29a/32/28802_2.png) [@bruno29a](https://forum.knime.com/u/bruno29a)\ **Post date:** [October 31, 2021, 8:53pm UTC](https://forum.knime.com/t/data-transforming/37060/4 "2021-10-31T20:53:06Z")
Hi @Vaze , the Table Creator is just a way to manually input data. You can just use an Excel Reader instead of the Table Creator since you have the data in Excel, or if you already have a workflow that’s reading the Excel file, you just need to use the Pivoting node with your workflow. My workflow is just meant as an example to help you see how the Pivoting node was configured based on the Table Creator. ---
**Author:** ![Vaze](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/v/a9a28c/32.png) [@Vaze](https://forum.knime.com/u/Vaze)\ **Post date:** [October 31, 2021, 8:54pm UTC](https://forum.knime.com/t/data-transforming/37060/5 "2021-10-31T20:54:16Z")
Thank you so much It worked out ---
**Author:** ![bruno29a](https://forum-cdn.knime.com/user_avatar/forum.knime.com/bruno29a/32/28802_2.png) [@bruno29a](https://forum.knime.com/u/bruno29a)\ **Post date:** [October 31, 2021, 8:55pm UTC](https://forum.knime.com/t/data-transforming/37060/6 "2021-10-31T20:55:02Z")
No problem @Vaze , happy to help ---
**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\ **Post date:** [November 7, 2021, 8:55pm UTC](https://forum.knime.com/t/data-transforming/37060/7 "2021-11-07T20:55:21Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.