Also LEAD() function can be used with COALESCE() For example    coalesce(sepan, lead(sepan, 1) over (partition by sourcedata order by timestamps)) as sepan   That will replace NULL values in sepan column with next non null value. The timestamps column could be ordered in asc order depending on the value you wan to copy. ... View more