New - March 2020 Update:
- OpenRefine 3.0, we have the coalesce() function: which natively handles the null correctly.
- OpenRefine 3.3 introduced a user interface that offers tons of flexibility. See tutorial
This tutorial has been merge with How to merge cells that have blank cells.
You can also refer to the following video tutorials: