Sum amount by grouping consecutive dates with 1 day of interval

[Vignesh_Raja]

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.

[danilang · Accepted solution]

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

[MarqueeCrew · Accepted solution]

@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