Concatenate multiple rows into single column

[LeoMessi]

Hi community, 

I am looking to concatenate multiple rows in to a single column, using record ID as a reference.

Attaching an excel for reference. 

Any solutions will be a great help!

Thank you!!

[Rhys_Cooper · Accepted solution]

Hi @LeoMessi. This can be achieved simply using the concatination function of the Sumarise tool, grouped by record ID. See the below screenshots for the configuration and the workflow attatched. Let me know if you have any quesitons or want an alternate solution. NOTE: Other is missing from the output as i lost it in copy and pasting your input table but the solution will still work and get your expected output!

[LeoMessi]

this is perfect, thank you @Rhys_Cooper !

Now on the next step, I want to create a column using this concatenated field, summarizing this as "Global", since we have multiple entries for APAC, and one for EMEA. 

How can I do this? Maybe using formula tool?  

[Rhys_Cooper]

Glad to have been able to have helped @LeoMessi 😁. I dont quite follow what you require next, please post the input and desired output as a new question and will certainly be able to give it a shot.

[binuacs]

@LeoMessi you can update the field name in the summarise tool to Global