I would like to organize the data per ID.
I am sending more examples. So, one thing that I need is: - for the first and last date: to add/classify with 'first"(group 1) or "last"(group 30 ALSO the day with ONE day of difference. For example, in this data, it can be observed for Id B, the last date is 30 August, but I also would like to classify it as late the day 29 August.
F0920419
Have
Want
Id
Date
Id
Date
Group
A
8-Aug-19
A
8-Aug-19
1
A
8-Aug-19
A
8-Aug-19
1
A
8-Aug-19
A
8-Aug-19
1
A
19-Aug-19
A
19-Aug-19
2
A
19-Aug-19
A
19-Aug-19
2
A
19-Aug-19
A
19-Aug-19
2
A
29-Aug-19
A
29-Aug-19
2
A
29-Aug-19
A
29-Aug-19
2
A
29-Aug-19
A
29-Aug-19
2
A
29-Aug-19
A
29-Aug-19
2
A
29-Aug-19
A
29-Aug-19
2
A
3-Sep-19
A
3-Sep-19
3
A
3-Sep-19
A
3-Sep-19
3
A
3-Sep-19
A
3-Sep-19
3
A
3-Sep-19
A
3-Sep-19
3
B
1-Aug-19
B
1-Aug-19
1
B
1-Aug-19
B
1-Aug-19
1
B
1-Aug-19
B
1-Aug-19
1
B
9-Aug-19
B
9-Aug-19
2
B
9-Aug-19
B
9-Aug-19
2
B
9-Aug-19
B
9-Aug-19
2
B
9-Aug-19
B
9-Aug-19
2
B
12-Aug-19
B
12-Aug-19
2
B
13-Aug-19
B
13-Aug-19
2
B
14-Aug-19
B
14-Aug-19
2
B
15-Aug-19
B
15-Aug-19
2
B
16-Aug-19
B
16-Aug-19
2
B
17-Aug-19
B
17-Aug-19
2
B
17-Aug-19
B
17-Aug-19
2
B
17-Aug-19
B
17-Aug-19
2
B
19-Aug-19
B
19-Aug-19
2
B
20-Aug-19
B
20-Aug-19
2
B
21-Aug-19
B
21-Aug-19
2
B
22-Aug-19
B
22-Aug-19
2
B
22-Aug-19
B
22-Aug-19
2
B
23-Aug-19
B
23-Aug-19
2
B
26-Aug-19
B
26-Aug-19
2
B
27-Aug-19
B
27-Aug-19
2
B
29-Aug-19
B
29-Aug-19
3
B
30-Aug-19
B
30-Aug-19
3
B
30-Aug-19
B
30-Aug-19
3
... View more