The column amount needs to be summarized based on consecutive dates with 1 day of interval with group by of Name.
Sample Input
Sample Output
Expecting your response at the earliest.
Hi @Vignesh_Raja
The tricky part in this one is determining which rows to group together. This is done in the multirow tool which starts a new group if the elapsed time is greater than one day for the current Name. Summarize and clean up leaves you with
Dan
@Vignesh_Raja ,
Your incoming data example seems to be in error. The first and second groups are consecutive. Here's a solution for you however:
Cheers,
Mark
