Sharepoint List Multiple Choice Field shows different if picked in different order

[DannyMac]

I have a choice field in a Sharepoint List, and if its picked in a different order it shows as different column in a chart.  The field is called RICEFW, and (For example) someone picks "Enhancement" and then "Interface", it shows a different column than if someone chooses "Interface" and then "Enhancement".  Help!  I would like to show them both in one column.

[amitchandak · Accepted solution]

@DannyMac , the expected output is not clear. But one of the ways is you break the column into multiple line using a delimiter

Split Column Power Query: https://youtu.be/FyO9Vmhcfag

[amitchandak · Accepted solution]

@DannyMac , the expected output is not clear. But one of the ways is you break the column into multiple line using a delimiter

Split Column Power Query: https://youtu.be/FyO9Vmhcfag

[DannyMac · Accepted solution]

@amitchandak , thats perfect thanks!  Now I have what I need;