Concatenating multiple fields

Question

I have bellow output from summarizing, what I want is to concatenate all the text fields with the comma that comes against single ASL Supplier number.

an example I see 0 has many fields, I should see only one 0 and all the text in one line separated with a comma. Please help

Concatenation issue.png

kat · Accepted Answer

Hi @skumari

You'll want to use a summarise tool and configure it like this:

the default separator is a comma.

Hope that helps!

Kat