SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE "holes" ("tournament" INTEGER, "year" INTEGER, "course" INTEGER, "round" INTEGER, "hole" INTEGER, "stimp" INTEGER);
✓
INSERT INTO "holes" VALUES
(33, 2016, 895, 1, 1, 12),(33, 2016, 895, 1, 2, 18),(33, 2016, 895, 1, 3, 15),(33, 2016, 895, 1, 4, 11),(33, 2016, 895, 1, 5, 18),(33, 2016, 895, 1, 6, 28),
(33, 2016, 895, 1, 7, 21),(33, 2016, 895, 1, 8, 14),(33, 2016, 895, 1, 9, 10),(33, 2016, 895, 1, 10, 11),(33, 2016, 895, 1, 11, 12),(33, 2016, 895, 1, 12, 18),
(33, 2016, 895, 1, 13, 15),(33, 2016, 895, 1, 14, 11),(33, 2016, 895, 1, 15, 18),(33, 2016, 895, 1, 16, 28), (33, 2016, 895, 1, 17, 21),(33, 2016, 895, 1, 18, 14),
  
(33, 2016, 895, 2, 1, 16),(33, 2016, 895, 2, 2, 17),(33, 2016, 895, 2, 3, 16),(33, 2016, 895, 2, 4, 17),(33, 2016, 895, 2, 5, 28),(33, 2016, 895, 2, 6, 20),
(33, 2016, 895, 2, 7, 25),(33, 2016, 895, 2, 8, 11),(33, 2016, 895, 2, 9, 11),(33, 2016, 895, 2, 10, 18),(33, 2016, 895, 2, 11, 25),(33, 2016, 895, 2, 12, 10),
(33, 2016, 895, 2, 13, 14),(33, 2016, 895, 2, 14, 14),(33, 2016, 895, 2, 15, 10),(33, 2016, 895, 2, 16, 19), (33, 2016, 895, 2, 17, 20),(33, 2016, 895, 2, 18, 19);
✓
SELECT tournament, year, course, round, 
       MAX(CASE WHEN hole = 1 THEN stimp END) AS "hole 1", 
       MAX(CASE WHEN hole = 2 THEN stimp END) AS "hole 2",
       MAX(CASE WHEN hole = 3 THEN stimp END) AS "hole 3",
       MAX(CASE WHEN hole = 4 THEN stimp END) AS "hole 4",
       MAX(CASE WHEN hole = 5 THEN stimp END) AS "hole 5",
       MAX(CASE WHEN hole = 6 THEN stimp END) AS "hole 6",
       MAX(CASE WHEN hole = 7 THEN stimp END) AS "hole 7",
       MAX(CASE WHEN hole = 8 THEN stimp END) AS "hole 8",
       MAX(CASE WHEN hole = 9 THEN stimp END) AS "hole 9",
       MAX(CASE WHEN hole = 10 THEN stimp END) AS "hole 10",
       MAX(CASE WHEN hole = 11 THEN stimp END) AS "hole 11",
       MAX(CASE WHEN hole = 12 THEN stimp END) AS "hole 12",
       MAX(CASE WHEN hole = 13 THEN stimp END) AS "hole 13",
       MAX(CASE WHEN hole = 14 THEN stimp END) AS "hole 14", 
       MAX(CASE WHEN hole = 15 THEN stimp END) AS "hole 15",
       MAX(CASE WHEN hole = 16 THEN stimp END) AS "hole 16",
       MAX(CASE WHEN hole = 17 THEN stimp END) AS "hole 17",
       MAX(CASE WHEN hole = 18 THEN stimp END) AS "hole 18"
FROM holes
GROUP BY tournament, year, course, round;


tournament
year
course
round
hole 1
hole 2
hole 3
hole 4
hole 5
hole 6
hole 7
hole 8
hole 9
hole 10
hole 11
hole 12
hole 13
hole 14
hole 15
hole 16
hole 17
hole 18


33
2016
895
1
12
18
15
11
18
28
21
14
10
11
12
18
15
11
18
28
21
14

33
2016
895
2
16
17
16
17
28
20
25
11
11
18
25
10
14
14
10
19
20
19

tournament	year	course	round	hole 1	hole 2	hole 3	hole 4	hole 5	hole 6	hole 7	hole 8	hole 9	hole 10	hole 11	hole 12	hole 13	hole 14	hole 15	hole 16	hole 17	hole 18
33	2016	895	1	12	18	15	11	18	28	21	14	10	11	12	18	15	11	18	28	21	14
33	2016	895	2	16	17	16	17	28	20	25	11	11	18	25	10	14	14	10	19	20	19