Grouping of the values in column A and the different values in column B as separate columns in th...

Hi!

I cannot find a solution to the following problem. I am still new to KNIME but it should be easy…

I have:

| A    | B |
| Val1 | 1 |
| Val1 | 2 |
| Val1 | 3 |
| Val2 | 4 |
| Val2 | 5 |
| Val3 | 6 |

I want as output:

| A    | B_1 | B_2 | B_3 |
| Val1 | 1   | 2   | 3   |
| Val2 | 4   | 5   |     |
| Val3 | 6   |     |     |

i tried with a combination of groupby-node and pivot-node but i cannot get it to work.

any ideas?

Thank you!