How to split rows of data?

[lindstroem]

I have data, where one row, show one case, with a date for received, settled and finished:

CaseID	Date received	Date settled	Date finished
1	12/6/2024	14/6/2024	15/6/2024

I would rather have a single date variable like so:

CaseID	Received/settled/finished	Date
1	Received	12/6/2024
1	Settled	14/6/2024
1	Finished	15/6/2024

Is this possible and if so, how to?

[ayman_salem]

use cross table

 

[lindstroem]

That makes sense, can you maybe help me understand how you would do this for a data set with about 180.000 rows?

[nachtaktiv]

did you try the solution with your data set ?
you have 180K rows and not 180K columns !

[lindstroem]

.

[lindstroem]

I did try the solution, but it doesn't solve my problem. The problem isn't displaying the data, the problem is within the data it self. Every case has three date variables, and I'm wondering if it's possible to create one date variable.