Showing a list without separators

Hi Davina,

Theres a couple of options.

Option 1

If you go to the query editor and select Split Column by Delimiter as shown:

Split Column

Choose to split by the Semi Colon if it isnt already selected

Split Column

Select the Category Column as shown, then choose Unpivot Other Columns.

Unpivot

The 'Category' and 'Value' columns show the information you requested.

Review

Option 2

Alternatively, another option is to use the 'Replace Values' command.

Select the Values Column, then choose 'Replace Values' to replace the semicolon with a Carriage Return and Line Feed.

Replace delimiter with Carraige Return and Line Feed

This will provide the data as shown if this is preferable.

Redults

Hopefully this answers your question Anonymous - Its the first one i've answered on this forum so would appreciate if you could let me know.

Cheers,

Richard