All Values in one Row

[mr_lampert]

Hello Community,

simple question: in this small table are different values:

Load * Inline [
Number, Word
1, Delta
2, Bravo
1, Echo
2, Charlie
];

This is the table on the left in this screenshot:

How can I create a table (no pivot table), that looks like my masterful artwork on the right? It should show all possible values of another value in one row.

Thanks and greetings from Germany

David

[jaumecf23 · Accepted solution]

Use this in your expression -> Concat(Word,',')

[mr_lampert]

Concat? Perfect! Why can not things always be this easy?

Thank you Jaume!