Data Manupulation

[vamsey]

Hi Community,

I have data in this format 

ID
0
0
1
1
1
1
0
0
0
0
1
1
1
1
1

I need data to be in this format.

ID	ID_Sequence
0	1
0	1
1	2
1	2
1	2
1	2
0	3
0	3
0	3
0	3
1	4
1	4
1	4
1	4
1	4

Can anyone please help in restructuring this.

[Sebastiaandb]

Hi @vamsey ,

Here you go!

Hope it helps!

Greetings,

Seb

[OllieClarke]

Hey @Sebastiaandb 

You can do it without the recordID if you want:

[vamsey]

Thanks!! It helped