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!
>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.