# Column to row for selected columns

**URL:** <https://forum.knime.com/t/column-to-row-for-selected-columns/87706>\
**Category:** KNIME Analytics Platform\
**Created:** [April 22, 2025, 11:20am UTC](https://forum.knime.com/t/column-to-row-for-selected-columns/87706 "2025-04-22T11:20:19Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mac95](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/m/a5b964/32.png) [@mac95](https://forum.knime.com/u/mac95)\
**Post date:** [April 22, 2025, 11:20am UTC](https://forum.knime.com/t/column-to-row-for-selected-columns/87706/1 "2025-04-22T11:20:19Z")

</div>

Hi,

I’m trying to transform a table. It starts off with a key column and then three sets of columns. Each set contains an _Import_ column and a _Value_ column.

I’d like to transform this table so that there is only one _Import_ and _Value_ column, as per the attached images. Is this possible in KNIME?

![image](https://forum-cdn.knime.com/uploads/default/original/3X/f/7/f79ebab07e6faea5940c42e05e541bd288601b9c.png)

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/a/9/a9b94cee0fee331b81d56273691843d4e1e7c3cf.png)

---

<div class="post-metadata">

**Author:** ![MartinDDDD](https://forum-cdn.knime.com/user_avatar/forum.knime.com/martindddd/32/69988_2.png) [@MartinDDDD](https://forum.knime.com/u/MartinDDDD)\
**Post date:** [April 22, 2025, 11:41am UTC](https://forum.knime.com/t/column-to-row-for-selected-columns/87706/2 "2025-04-22T11:41:21Z")

</div>

Hey there,

it is definitely possible and there will be many different ways to get to that result.

I’ve chose to Unpivot the dataset, then to group into Type Import or Type value and then to Pivot again:

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/9/8/98e731e1af3a7fed7d0af51a5430fae9b18d56f2.png)

I just used one of your rows (do not enjoy typing data manually a lot…)

Workflow:  
[unpivotexample.knwf](https://forum.knime.com/uploads/short-url/kMKJ4DByRA8otriDiOSiH7FtmuQ.knwf) (78.4 KB)

---

<div class="post-metadata">

**Author:** ![ActionAndi](https://forum-cdn.knime.com/user_avatar/forum.knime.com/actionandi/32/76198_2.png) [@ActionAndi](https://forum.knime.com/u/ActionAndi)\
**Post date:** [April 22, 2025, 4:14pm UTC](https://forum.knime.com/t/column-to-row-for-selected-columns/87706/3 "2025-04-22T16:14:04Z")

</div>

Martins Solution is already brilliant, but as he said there are many ways to get the result. Mine is the following:

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

---

<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:** [July 21, 2025, 4:14pm UTC](https://forum.knime.com/t/column-to-row-for-selected-columns/87706/4 "2025-07-21T16:14:10Z")

</div>

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