Oracle 11g Release 2

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

CREATE TABLE CUST_DATA
  (ID, Name, City, State, State2, State3, Zip, Country, Phone, Order_Year, Order_Status) AS
SELECT 111, 'Bob', 'Anytown', 'MP', NULL, NULL, 55555, 'US', '555-5555', 2020, 'Valid' FROM DUAL UNION ALL
SELECT 111, 'Bob', 'Anytown', 'MP', 'MP', 'MP', 55555, NULL, '555-5555', 2020, 'Valid' FROM DUAL
2 rows affected

SELECT *
  FROM CUST_DATA;


ID
NAME
CITY
STATE
STATE2
STATE3
ZIP
COUNTRY
PHONE
ORDER_YEAR
ORDER_STATUS


111
Bob
Anytown
MP
null
null
55555
US
555-5555
2020
Valid

111
Bob
Anytown
MP
MP
MP
55555
null
555-5555
2020
Valid


SELECT DISTINCT d1.ID,
                COALESCE(d1.NAME, d2.NAME) AS NAME,
                COALESCE(d1.City, d2.City) AS City,
                COALESCE(d1.State, d2.State) AS State,
                COALESCE(d1.State2, d2.State2) AS State2,
                COALESCE(d1.State3, d2.State3) AS State3,
                COALESCE(d1.Zip, d2.Zip) AS Zip,
                COALESCE(d1.Country, d2.Country) AS Country,
                COALESCE(d1.Phone, d2.Phone) AS Phone,
                COALESCE(d1.Order_Year, d2.Order_Year) AS Order_Year,
                COALESCE(d1.Order_Status, d2.Order_Status) AS Order_Status
  FROM CUST_DATA d1
  LEFT OUTER JOIN CUST_DATA d2
    ON d2.ID = d1.ID AND
       d2.ROWID <> d1.ROWID


ID
NAME
CITY
STATE
STATE2
STATE3
ZIP
COUNTRY
PHONE
ORDER_YEAR
ORDER_STATUS


111
Bob
Anytown
MP
MP
MP
55555
US
555-5555
2020
Valid

ID	NAME	CITY	STATE	STATE2	STATE3	ZIP	COUNTRY	PHONE	ORDER_YEAR	ORDER_STATUS
111	Bob	Anytown	MP	null	null	55555	US	555-5555	2020	Valid
111	Bob	Anytown	MP	MP	MP	55555	null	555-5555	2020	Valid