[Basic] Grouping and Pivoting a table

Hi,

I’m struggling with a basic operation (I am still discovering Knime :sweat_smile:)

I have the following table

| User   | Answer          |
| User 1 | User 1_Answer 1 |
| User 2 | User 2_Answer 1 |
| User 3 | User 3_Answer 1 |
| User 4 | User 4_Answer 1 |
| User 5 | User 5_Answer 1 |
| User 1 | User 1_Answer 2 |
| User 2 | User 2_Answer 2 |
| User 3 | User 3_Answer 2 |
| User 4 | User 4_Answer 2 |
| User 5 | User 5_Answer 2 |
| …      | …               |

And I’d like to pivot the table like this:

| User   | Answer 1        | Answer 2        |
| User 1 | User 1_Answer 1 | User 1_Answer 2 |
| User 2 | User 2_Answer 1 | User 2_Answer 2 |
| User 3 | User 3_Answer 1 | User 3_Answer 2 |
| User 4 | User 4_Answer 1 | User 4_Answer 2 |
| User 5 | User 5_Answer 1 | User 5_Answer 2 |

My first idea would be to add a “Group” column to the table and then pivot it:

| User   | Answer          | Group |
| User 1 | User 1_Answer 1 | 1     |
| User 2 | User 2_Answer 1 | 1     |
| User 3 | User 3_Answer 1 | 1     |
| User 4 | User 4_Answer 1 | 1     |
| User 5 | User 5_Answer 1 | 1     |
| User 1 | User 1_Answer 2 | 2     |
| User 2 | User 2_Answer 2 | 2     |
| User 3 | User 3_Answer 2 | 2     |
| User 4 | User 4_Answer 2 | 2     |
| User 5 | User 5_Answer 2 | 2     |
| …      | …               | …     |

But even adding the

Group

column is not so easy (at least for me ^^).

I tried to increase the

Group

value every time we “reach” a “User 1” row but did not find a proper way to do it.

All in all, I suspect there would be a much more efficient way to go from the initial state of my table to the expected output.

Thanks,

Pierre-Louis