How to merge records from different columns

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: