pythonjythondata-cleaningopenrefinegrel

OpenRefine - combining rows into one record


I have a dataset with records that have been split across multiple rows. Is there an easy way to combine these values into one row?

screenshot of dataset

The screenshot shows what I have at present. The ID column has the same value, but the dates have been scattered across different rows. I want to have these all on just one row.

Thanks for your help!


Solution

  • I am assuming that the ID column is already sorted and it is the first column.

    If this is the case you can create records by using Edit cells => Blank down on your ID column.

    After switching to "record mode" (see the interface description) you can use Edit cells => Join multi-valued cells... on each date column.