Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TABLE table_name (ID, NAME) AS
SELECT 1, 'Jim' FROM DUAL UNION ALL
SELECT 1, 'Joe' FROM DUAL UNION ALL
SELECT 2, 'Jak' FROM DUAL UNION ALL
SELECT 2, 'Den' FROM DUAL UNION ALL
SELECT 2, 'Din' FROM DUAL UNION ALL
SELECT 3, 'Kos' FROM DUAL UNION ALL
SELECT 3, 'Kos2' FROM DUAL UNION ALL
SELECT 3, 'Sah' FROM DUAL;
8 rows affected

SELECT *
FROM   (
  SELECT t.*,
         ROW_NUMBER() OVER (PARTITION BY id ORDER BY name) AS rn
  FROM   table_name t
)
PIVOT (
  MAX(name)
  FOR rn IN (1 AS name1, 2 AS name2, 3 AS name3, 4 AS name4)
)


ID
NAME1
NAME2
NAME3
NAME4


1
Jim
Joe
null
null

2
Den
Din
Jak
null

3
Kos
Kos2
Sah
null


SELECT id,
       MAX(CASE rn WHEN 1 THEN name END) AS name1,
       MAX(CASE rn WHEN 2 THEN name END) AS name2,
       MAX(CASE rn WHEN 3 THEN name END) AS name3,
       MAX(CASE rn WHEN 4 THEN name END) AS name4
FROM   (
  SELECT t.*,
         ROW_NUMBER() OVER (PARTITION BY id ORDER BY name) AS rn
  FROM   table_name t
)
GROUP BY id


ID
NAME1
NAME2
NAME3
NAME4


1
Jim
Joe
null
null

2
Den
Din
Jak
null

3
Kos
Kos2
Sah
null