By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT *
INTO YourTable
FROM (VALUES
('A', 1),
('A', 2),
('A', 3),
('B', 1),
('B', 2),
('B', 3),
('B', 4),
('C', 1),
('C', 2) )V(Code, ColVal)
9 rows affected
SELECT A, B, C
FROM (
SELECT Code,
ColVal,
ROW_NUMBER() OVER (PARTITION BY Code ORDER BY ColVal) AS RN
FROM YourTable) TBL
PIVOT (MAX(ColVal) FOR Code IN (A,B,C)) AS pvt
| A | B | C |
|---|---|---|
| 1 | 1 | 1 |
| 2 | 2 | 2 |
| 3 | 3 | null |
| null | 4 | null |