Convert Multiple rows to single variable

[elaenscetric]

I was having data like 

Values
ab
cd
ef

I need to convert to a single variable as 'ab','cd','ef'

Also number values not only 3 & it should be dynamic.

[Christina_H · Accepted solution]

Use a summarise tool to concatenate the values.  You can set the prefix, separator and suffix to include the quotes and commas.

[afv2688 · Accepted solution]

Hello @elaenscetric ,

you can easily do that by using the summarize tool with the concatenate option. The only thing would be to pay attention to the start, separator and end options.

Regards