Qlik Sense concatenating multiple rows into one cell

[firmographs]

We have data in rows, like this:

A, 1

A, 2

A, 3

B, 1

B, 6

For  a CRM-related project, we want to concatenate all of the "A" and "B" data together, in a cell, that would look like this:

A, 1 2 3

B, 1 6

In other words, we would combine the second column of data in a single table cell for each distinct value of the first column.  

Is this achievable using a load script with Qlik Sense Enterprise?

[Vegar]

Try this approach.

LOAD

LetterField as Letter,

Concat(distinct NumberField, ' ') as Numbers

FROM Data

GROUP BY  LetterField;