By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table models (ID_ACC int, Model_1 varchar(100), Model_2 varchar(100), Model_3 varchar(100), actual varchar(10));
insert into models values (1, 'm1_val1', 'm2_val1', 'm3_val1', 'val1');
1 rows affected
insert into models values (2, 'm1_val2', 'm2_val2', 'm3_val2', 'val2');
1 rows affected
insert into models values (3, 'm1_val3', 'm2_val3', 'm3_val3', 'val3');
1 rows affected
insert into models values (4, 'm1_val4', 'm2_val4', 'm3_val4', 'val4');
1 rows affected
insert into models values (5, 'm1_val5', 'm2_val5', 'm3_val5', 'val5');
1 rows affected
select id_acc, model, value, actual
from models
unpivot (value for model in (model_1 as 'Model 1', model_2 as 'Model 2', model_3 as 'Model 3'));
| ID_ACC | MODEL | VALUE | ACTUAL |
|---|---|---|---|
| 1 | Model 1 | m1_val1 | val1 |
| 1 | Model 2 | m2_val1 | val1 |
| 1 | Model 3 | m3_val1 | val1 |
| 2 | Model 1 | m1_val2 | val2 |
| 2 | Model 2 | m2_val2 | val2 |
| 2 | Model 3 | m3_val2 | val2 |
| 3 | Model 1 | m1_val3 | val3 |
| 3 | Model 2 | m2_val3 | val3 |
| 3 | Model 3 | m3_val3 | val3 |
| 4 | Model 1 | m1_val4 | val4 |
| 4 | Model 2 | m2_val4 | val4 |
| 4 | Model 3 | m3_val4 | val4 |
| 5 | Model 1 | m1_val5 | val5 |
| 5 | Model 2 | m2_val5 | val5 |
| 5 | Model 3 | m3_val5 | val5 |