London 
   SOO
   Val
   Gatwick 

CREATE TABLE STG_TEST_DATA(ID NUMBER , VAL VARCHAR2(2000));

INSERT INTO STG_TEST_DATA VALUES( 3,'OTHR
LB
Val
Kenn / Cam Tn via Charing X');

INSERT INTO STG_TEST_DATA VALUES( 2,'CONTACT
LAS
Val
Updated');

id    Key       value
3      OTHR      LB
3      Val       Kenn / Cam Tn via Charing X
2      OTHR      LAS
2      Val       Updated

SQL> col Key format a10
SQL> col value format a30
SQL> with
  2    data  as (
  3      select id, column_value-1 nb, regexp_substr(val, '[^'||chr(10)||']+', 1, column_value) val
  4      from STG_TEST_DATA,
  5           table(cast(multiset(select level from dual
  6                               connect by level <= regexp_count(val,chr(10))+1)
  7                 as sys.odciNumberList))
  8    )
  9  select id,
 10         max(decode(mod(nb,2),0,val)) "Key",
 11         max(decode(mod(nb,2),1,val)) "value"
 12  from data
 13  group by id, trunc(nb/2)
 14  order by id, trunc(nb/2)
 15  /
        ID Key        value
---------- ---------- ------------------------------
         2 CONTACT    LAS
         2 Val        Updated
         3 OTHR       LB
         3 Val        Kenn / Cam Tn via Charing X

4 rows selected.