By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE T5 (idnum NUMBER,f1 NUMBER(10,5),f2 NUMBER(10,5),f3 NUMBER(10,5),e1 NUMBER(10,5),e2 NUMBER(10,5),h1 NUMBER(10,5),h2 NUMBER(10,5));
INSERT INTO T5 (IDNUM,F1,F2,F3,E1,E2,H1,H2) VALUES (1,'10.2004','5.009','7.330','9.008','8.003','.99383','1.43243');
1 rows affected
INSERT INTO T5 (IDNUM,F1,F2,F3,E1,E2,H1,H2) VALUES (2,'4.2004','6.009','9.330','4.7008','4.60333','1.993','3.3243');
1 rows affected
INSERT INTO T5 (IDNUM,F1,F2,F3,E1,E2,H1,H2) VALUES (3,'10.2040','52.6009','67.330','9.5008','8.003','.99383','1.43243');
1 rows affected
INSERT INTO T5 (IDNUM,F1,F2,F3,E1,E2,H1,H2) VALUES (4,'9.20704','45.009','17.330','29.008','5.003','3.9583','1.243');
1 rows affected
CREATE TABLE T5_unpiv(IDNUM NUMBER, SK NUMBER, F NUMBER, E NUMBER, H NUMBER, F_COL_NAME VARCHAR2(100));
INSERT ALL
INTO T5_unpiv(IDNUM, SK, F, E,H, F_COL_NAME) VALUES (idnum,1,f1,e1,h1,'F1')
INTO T5_unpiv(IDNUM, SK, F, E,H, F_COL_NAME) VALUES (idnum,2,f2,e2,h2,'F2')
INTO T5_unpiv(IDNUM, SK, F, E,H, F_COL_NAME) VALUES (idnum,3,f3,NULL,NULL,'F3')
SELECT *
FROM T5;
12 rows affected
SELECT *
FROM T5_unpiv
ORDER BY IDNUM, sk;
| IDNUM | SK | F | E | H | F_COL_NAME |
|---|---|---|---|---|---|
| 1 | 1 | 10.2004 | 9.008 | .99383 | F1 |
| 1 | 2 | 5.009 | 8.003 | 1.43243 | F2 |
| 1 | 3 | 7.33 | null | null | F3 |
| 2 | 1 | 4.2004 | 4.7008 | 1.993 | F1 |
| 2 | 2 | 6.009 | 4.60333 | 3.3243 | F2 |
| 2 | 3 | 9.33 | null | null | F3 |
| 3 | 1 | 10.204 | 9.5008 | .99383 | F1 |
| 3 | 2 | 52.6009 | 8.003 | 1.43243 | F2 |
| 3 | 3 | 67.33 | null | null | F3 |
| 4 | 1 | 9.20704 | 29.008 | 3.9583 | F1 |
| 4 | 2 | 45.009 | 5.003 | 1.243 | F2 |
| 4 | 3 | 17.33 | null | null | F3 |