cancel
Showing results for 
Search instead for 
Did you mean: 

How to split rows of data?

lindstroem
Explorer
0 Kudos
166

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

CaseIDDate receivedDate settledDate finished
112/6/202414/6/202415/6/2024

I would rather have a single date variable like so:

CaseIDReceived/settled/finishedDate
1Received12/6/2024
1Settled14/6/2024
1Finished15/6/2024

Is this possible and if so, how to?

View Entire Topic
ayman_salem
Active Contributor
0 Kudos

use cross table

ayman_salem_0-1719236197338.png 

ayman_salem_1-1719236310690.png

 

  

 

lindstroem
Explorer
0 Kudos
That makes sense, can you maybe help me understand how you would do this for a data set with about 180.000 rows?
nachtaktiv
Participant
0 Kudos

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

lindstroem
Explorer
0 Kudos

.

lindstroem
Explorer
0 Kudos
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.