Converting Comma Seperated string into list

I made another post but this more succintly describes the issue I am having:

I have an API connection that either dumps a JSON file that is all or nothing. I have to make a list that displays thousands of different items with their respective details.
Here is an example of what I would like it to look like:

Here is what it actually looks like.

I want one number to display on each line, so I can sort the following cells. Every time I try to use the sort function, I get empty commas.