OpenRefine - combining rows into one record

Question

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?

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!

user_16592991 · Answer

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.

OpenRefine - combining rows into one record

1 Answers