By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE data (exclusion varchar(40))
insert into data values
('0.0000, 3546.0000, 253422.000'),
('4.234, 1.04, 235.99')
2 rows affected
WITH CTE AS (
SELECT exclusion, value, ROW_NUMBER() OVER (PARTITION BY exclusion ORDER BY (SELECT NULL)) AS rn
FROM data
CROSS APPLY STRING_SPLIT(exclusion, ',')
)
SELECT exclusion,
[1] AS Val1,
[2] AS Val2,
[3] AS Val3
FROM CTE
PIVOT (
MAX(value)
FOR rn IN ([1], [2], [3])
) p
| exclusion | Val1 | Val2 | Val3 |
|---|---|---|---|
| 0.0000, 3546.0000, 253422.000 | 0.0000 | 3546.0000 | 253422.000 |
| 4.234, 1.04, 235.99 | 4.234 | 1.04 | 235.99 |