You can easily write a function that cracks a comma-separated list into table format.
On my web site I have an article that shares some simple functions for this purpose, and there is also a section for how to deal with a comma-separated list in a table: https://www.sommarskog.se/arrays-in-sql.html.