Sort values separated by semicolon

[mer]

How do I sort values within a field that's separated by a semicolon in Alteryx? 

[Qiu · Accepted solution]

@mer 
We first can use the "Text to Column" tool to seperate the States in the State Field, then do the sorting and use a Summarize tool.

Strictly speaking, the fields are sepeted by a semicon and a space.

[Raj]

@mer this including separating values to rows using delimiter, sorting them on order and then concatenating then using summarize tool.

[mer]

Thank you!