SQL将逗号分隔的字符串拆分为多个列

I am newish to SQL to please excuse any ignorance. I have a table, called 'temp' that contains one Field, (called Field1) with rows and rows of long comma seperated strings, thus:I am newish to SQL to please excuse any ignoran