# Rows to columns

**URL:** <https://forum.knime.com/t/rows-to-columns/45714>\
**Category:** KNIME Analytics Platform\
**Created:** [August 4, 2022, 3:29pm UTC](https://forum.knime.com/t/rows-to-columns/45714 "2022-08-04T15:29:02Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![zielinska\_km](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/z/c68b51/32.png) [@zielinska\_km](https://forum.knime.com/u/zielinska_km)\
**Post date:** [August 4, 2022, 3:29pm UTC](https://forum.knime.com/t/rows-to-columns/45714/1 "2022-08-04T15:29:02Z")

</div>

Hello,

This is my input:

Number Letter Number3  
1111111 A 0987543  
1111111 B 72819746  
1111111 C 4621716  
222222 A 82917253  
222222 B 73828122

I need this output:

Number A B C  
111111 0987543 72819746 4621716  
222222 82917253 73828122 -

Do you know if its possible to acquire? What nodes should I use?

Best Regards

---

<div class="post-metadata">

**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:** [August 4, 2022, 3:56pm UTC](https://forum.knime.com/t/rows-to-columns/45714/2 "2022-08-04T15:56:55Z")

</div>

Hi @zielinska_km and welcome to the Knime Community.

You should be able to do this using the Pivoting node:

> **[Pivoting](https://hub.knime.com/knime/extensions/org.knime.features.base/latest/org.knime.base.node.preproc.pivot.Pivot2NodeFactory)**
>
> Performs a pivoting on the given input table using a selected number of columns for grouping and pivoting. The group columns will result into unique rows, wher…

EDIT: Here’s a quick solution I put together in case you can’t figure it out:  
 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/2/7/276c7cd0c3bbb35db391dce968f2e67740eab07d.png)

Input (Same as yours):  
 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/b/d/bd82662996b438b7ddc11c11344b9d1ccff3ae18.png)

Results:  
 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/e/3/e30d5ace82df0a1054245495f709e974fad5e7e0.png)

Here’s the workflow:

> **[Rows to columns – bruno29a](https://hub.knime.com/bruno29a/spaces/Public/latest/Forum/Rows%20to%20columns~WaJEbegJTzdBXmdx)**
>
> Rows to columns using Pivoting Request: This is my input: Number Letter Number3 1111111 A 0987543 1111111 B 72819746 1111111 C 4621716 222222 A 82917253 222222…

---

<div class="post-metadata">

**Author:** ![zielinska\_km](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/z/c68b51/32.png) [@zielinska\_km](https://forum.knime.com/u/zielinska_km)\
**Post date:** [August 5, 2022, 7:46am UTC](https://forum.knime.com/t/rows-to-columns/45714/3 "2022-08-05T07:46:38Z")

</div>

> [@bruno29a](#):
>
> [Rows to columns – KNIME Community Hub](https://hub.knime.com/bruno29a/spaces/Public/latest/Forum/Rows%20to%20columns~WaJEbegJTzdBXmdx)

Thank you! It works properly.

---

<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:** [August 12, 2022, 7:46am UTC](https://forum.knime.com/t/rows-to-columns/45714/4 "2022-08-12T07:46:52Z")

</div>

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