Convert Multiple rows to single variable

Question

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 Answer

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

afv2688 · Accepted Answer

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