split(A2,",")

纵向扩展就行了。。

如果要在一行中展示成类似4行的

就用公式形态设置

replace($$$,",","\n")

split(B2,",") 然后设置纵向扩展

------------

不想扩展就换成 replace(b2,",","\n")

SQL可以解决

SELECT REGEXP_SUBSTR(COL_VALUE, '[^,]+', 1, ROWNUM) AS SPECIFICATIONID

  FROM (SELECT 'A,B,C,D,E,F' AS COL_VALUE FROM DUAL) T

CONNECT BY ROWNUM <=

           LENGTH(COL_VALUE) - LENGTH(REGEXP_REPLACE(COL_VALUE, ',', '')) + 1