By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
WITH yourTable AS (
SELECT 56 AS ID, 'A,C' AS [Group], 'Z,Y' AS Category UNION ALL
SELECT 57, 'G,H', 'S,T' UNION ALL
SELECT 58, 'B,D', 'W,X' UNION ALL
SELECT 59, 'E,F', 'U,V'
)
SELECT
ID,
SUBSTRING([Group], 1, CHARINDEX(',', [Group]) - 1) AS [Group],
SUBSTRING([Category], 1, CHARINDEX(',', [Category]) - 1) AS Category
FROM yourTable
UNION ALL
SELECT
ID,
SUBSTRING([Group], CHARINDEX(',', [Group]) + 1, LEN([Group])),
SUBSTRING([Category], CHARINDEX(',', [Category]) + 1, LEN([Category]))
FROM yourTable
ORDER BY
ID,
[Group];
| ID | Group | Category |
|---|---|---|
| 56 | A | Z |
| 56 | C | Y |
| 57 | G | S |
| 57 | H | T |
| 58 | B | W |
| 58 | D | X |
| 59 | E | U |
| 59 | F | V |