By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE your_table (column1, column2, column3, column4) AS
SELECT 'id', 1, 2, 3 FROM DUAL UNION ALL
SELECT 'price', 5, 5, 7 FROM DUAL UNION ALL
SELECT 'old_price', 5, 5, 8 FROM DUAL;
3 rows affected
SELECT column1, column2, column4
FROM your_table
| COLUMN1 | COLUMN2 | COLUMN4 |
|---|---|---|
| id | 1 | 3 |
| price | 5 | 7 |
| old_price | 5 | 8 |