Input dt
date , activityname
11/12/20 , A
12/30/20, B
11/24/20, A
11/29/20,A
1/3/21, B
2/3/21,C
expected outputcome-
Start date , end date , activityname
11/12/20 , 11/29/20 , A
12/30/20 , 1/3/21 , B
2/3/21, 2/3/21, C
Input dt
date , activityname
11/12/20 , A
12/30/20, B
11/24/20, A
11/29/20,A
1/3/21, B
2/3/21,C
expected outputcome-
Start date , end date , activityname
11/12/20 , 11/29/20 , A
12/30/20 , 1/3/21 , B
2/3/21, 2/3/21, C
Hi @Tate_S
I hope this workflow can help you solve your problem.
Have a look at the attached workflow file. You can do some edits if you need.
DateRange.zip (3.8 KB)
Cheers