Using multirow formula between two columns

[PNC97]

I'm trying for a solution where multiple columns has datetime as below table.

I've tried using multirow formula "IF ID = Row-1:ID And End = Row-1:Start  and applied rank formula but I'm not getting expected output.

And I'm trying to find a solution where to get an expected output in excel sheet.

Thanks for the help in advance.

[apathetichell]

You use multi-row formula to compare [startdatetime] to [Row-1:enddatetime]... something like

create new field index (integer)

group by ID

if [Row-1:startdatetime]=null() then 1 elseif [startdatetime]!=[Row-1:enddatetime] then [Row-1:Index]+1 else [Row-1:Index] endif

thats step 1.

Step 2 is you use a summarize tool to group by ID/Index and take min start time and max end time.

[Qiu · Accepted solution]

@PNC97 
 I have basically followed the idea of @apathetichell and prepared a sample flow.