Last tested: Nov 2, 2018
There are several methods mostly using the first_value() window function, so results may vary based on your SQL dialect.
If your result set is less than 5000 rows, this Table Calculation pattern will work:
To find the first non-null record in column
More details on this article.