Sometimes you will have columns with lots of pieces of data all bunched together. There are several ways OpenRefine allows you to separate these pieces of data into more useful divisions, either into new columns or into a multi-row record.
NOTE: It is important to reset all facets on the column you wish to work with before beginning this process.
NOTE: The new rows will still be part of the same record. For more information on rows and records see the Layout section.
In OpenRefine 2.8, the pop-up window referred to in step 3 above appears differently (see below) and allows for more options and control when splitting cells. The options are:
8/17/2018 - Brinna Michael