Rows to columns

[zielinska_km]

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

[bruno29a]

Hi @zielinska_km and welcome to the Knime Community.

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

Pivoting

EDIT: Here’s a quick solution I put together in case you can’t figure it out:

Input (Same as yours):

Results:

Here’s the workflow:

Rows to columns – bruno29a

[zielinska_km]

@bruno29a

Rows to columns – KNIME Community Hub

Thank you! It works properly.