Concat data from varying number of rows

[Frndly]

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

[davidskaife · Accepted solution]

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

[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!