댓글이 안달아지네요..ㅎ

select col1, col2, 
       substr(last_value(decode(col1,null, null, col1||col2) ignore nulls) over (order by rownum),-3) val
  from t