Concat data from varying number of rows

Hello!

So I have set of data like this(left table on the screenshot). I know how to spread correct IDs using multirow formula, and if the data was numeric I would've just summed it up, but in this case the data is not numeric, I need to concat it. What would be the best approach to do so? In the screenshot right table is what I'm trying to achieve

Screenshot 2025-03-14 174751.png

Dynamic Processing

Accepted answers

davidskaife

Hi @Frndly

On the Summerize tool there is a Concatenate option, its under the String sub-category. Simply group by ID (after filling in the blank rows) and concatenate on the data. You can select the separator as well, which is set to a comma as a default

All comments

davidskaife

Hi @Frndly

OTrieger

@Frndly

Or you can use Cross Tab tool as it will also have Concatenate option

Frndly

Oh, that's somehow omitted me. Thank you!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703