Concatenating multiple fields

[skumari]

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

[kat · Accepted solution]

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