Hello,
I need your help. I'm looking for a workflow to transform my keys and values into a list. Here is an example:
I have this table:
| Key | Value |
| a | 1 |
| b | 2 |
| c | 3 |
| a | 4 |
| b | 5 |
| c | 6 |
| a | 7 |
| b | 8 |
| c | 9 |
and I wanna transform it to
| a | b | c |
| 1 | 2 | 3 |
| 4 | 5 | 6 |
| 7 | 8 | 9 |
Thank you
Hello,
I need your help. I'm looking for a workflow to transform my keys and values into a list. Here is an example:
I have this table:
| Key | Value |
| a | 1 |
| b | 2 |
| c | 3 |
| a | 4 |
| b | 5 |
| c | 6 |
| a | 7 |
| b | 8 |
| c | 9 |
and I wanna transform it to
| a | b | c |
| 1 | 2 | 3 |
| 4 | 5 | 6 |
| 7 | 8 | 9 |
Thank you
Hi
A possible way is shown as the screenshot below. See also the attached workspace example.

Hi
A possible way is shown as the screenshot below. See also the attached workspace example.

Awesome
Thank you for your help guys, it works perfectly