1

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!

Hev
  • 35
  • 3

1 Answers1

4

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.

b2m
  • 529
  • 3
  • 11