# Turn columns into rows

**URL:** <https://forum.knime.com/t/turn-columns-into-rows/39992>\
**Category:** KNIME Analytics Platform\
**Created:** [February 18, 2022, 5:51pm UTC](https://forum.knime.com/t/turn-columns-into-rows/39992 "2022-02-18T17:51:01Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Andrea\_Roma\_77](https://forum-cdn.knime.com/user_avatar/forum.knime.com/andrea_roma_77/32/31622_2.png) [@Andrea\_Roma\_77](https://forum.knime.com/u/Andrea_Roma_77)\
**Post date:** [February 18, 2022, 5:51pm UTC](https://forum.knime.com/t/turn-columns-into-rows/39992/1 "2022-02-18T17:51:01Z")

</div>

Hello.  
I need to turn columns into rows by pivoting on the ID column.  
Which NODE do you recommend and how should it be customized?  
Thank you

![pivot](https://forum-cdn.knime.com/uploads/default/original/3X/2/0/2034d5900bdb8cbae4014c698e01d234b4e8d11f.png)

---

<div class="post-metadata">

**Author:** ![aworker](https://forum-cdn.knime.com/user_avatar/forum.knime.com/aworker/32/36421_2.png) [@aworker](https://forum.knime.com/u/aworker)\
**Post date:** [February 18, 2022, 6:41pm UTC](https://forum.knime.com/t/turn-columns-into-rows/39992/2 "2022-02-18T18:41:52Z")

</div>

Chiao @Andrea_Roma_77

The solution I’m proposing here is based on grouping and splitting:

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/d/5/d5b756018769be8eebba4c661832da23080d84be.png)

[20220218 PIkairos Turn columns into rows.knwf](https://forum.knime.com/uploads/short-url/6YkhCRe2YbjhlV1UYve9eGA3lhU.knwf) (34.9 KB)

Hope it helps

Best

Ael

---

<div class="post-metadata">

**Author:** ![Andrea\_Roma\_77](https://forum-cdn.knime.com/user_avatar/forum.knime.com/andrea_roma_77/32/31622_2.png) [@Andrea\_Roma\_77](https://forum.knime.com/u/Andrea_Roma_77)\
**Post date:** [February 19, 2022, 7:54am UTC](https://forum.knime.com/t/turn-columns-into-rows/39992/3 "2022-02-19T07:54:21Z")

</div>

WOW!  
Thank you!  
Just what I needed. 🙇🏼‍♂️

---

<div class="post-metadata">

**Author:** ![aworker](https://forum-cdn.knime.com/user_avatar/forum.knime.com/aworker/32/36421_2.png) [@aworker](https://forum.knime.com/u/aworker)\
**Post date:** [February 21, 2022, 3:40pm UTC](https://forum.knime.com/t/turn-columns-into-rows/39992/4 "2022-02-21T15:40:43Z")

</div>

Ciao @Andrea_Roma_77

> [@Andrea\_Roma\_77](#):
>
> WOW!  
> Thank you!  
> Just what I needed. 🙇🏼‍♂️

Felice di sapere che ha funzionato 😃 👍

---

<div class="post-metadata">

**Author:** ![Daniel\_Weikert](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/d/e47c2d/32.png) [@Daniel\_Weikert](https://forum.knime.com/u/Daniel_Weikert)\
**Post date:** [February 21, 2022, 5:34pm UTC](https://forum.knime.com/t/turn-columns-into-rows/39992/5 "2022-02-21T17:34:32Z")

</div>

I borrowed @aworker great solution as source an used the following way  
 ![save](https://forum-cdn.knime.com/uploads/default/original/3X/e/5/e569700e6aa7474a311d97b604e888b4bda6a084.png)

Always great to learn various ways for me. Thanks for sharing @aworker

---

<div class="post-metadata">

**Author:** ![duristef](https://forum-cdn.knime.com/user_avatar/forum.knime.com/duristef/32/37106_2.png) [@duristef](https://forum.knime.com/u/duristef)\
**Post date:** [February 21, 2022, 8:04pm UTC](https://forum.knime.com/t/turn-columns-into-rows/39992/6 "2022-02-21T20:04:52Z")

</div>

just a slight variation on @aworker’s solution [turn columns into rows – KNIME Hub](https://kni.me/w/Qhgk9ktVrEsFLqYw)

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [May 22, 2022, 8:05pm UTC](https://forum.knime.com/t/turn-columns-into-rows/39992/7 "2022-05-22T20:05:17Z")

</div>

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