By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table_name ( Jan, Feb, Mar, Apr, May ) AS
SELECT 899.20, 0, 0, 0, 899.20 FROM DUAL UNION ALL
SELECT 439.38, 485.29, 0, 0, 482.29 FROM DUAL;
2 rows affected
SELECT Jan,
CASE WHEN Feb > 0 THEN Feb
ELSE Jan END
AS Feb,
CASE WHEN Mar > 0 THEN Mar
WHEN Feb > 0 THEN Feb
ELSE Jan END
AS Mar,
CASE WHEN Apr > 0 THEN Apr
WHEN Mar > 0 THEN Mar
WHEN Feb > 0 THEN Feb
ELSE Jan END
AS Apr,
CASE WHEN May > 0 THEN May
WHEN Apr > 0 THEN Apr
WHEN Mar > 0 THEN Mar
WHEN Feb > 0 THEN Feb
ELSE Jan END
AS May
FROM table_name
| JAN | FEB | MAR | APR | MAY |
|---|---|---|---|---|
| 899.2 | 899.2 | 899.2 | 899.2 | 899.2 |
| 439.38 | 485.29 | 485.29 | 485.29 | 482.29 |