Finding a MIN and MAX across multiple rows

[JohnMaty]

I have the attached scenario in a data table.  These represent placement of kids by case # (Matter_ID)

I need to collapse the rows down by Placement and the time span.  For example, I have one kid that has been in 3 types of placement over different periods of time. I need to collapse the Placement - Supervised Independent Living down from 3 to 1 span that is 2011-10-01 to 2018-02-22 (the current date).

I don't know how to do that and this can happen to any placement type.  It needs to be by case (Matter_ID).  Any  help would be appreciated

[patrick_digan · Accepted solution]

@JohnMaty Hopefully the attached will point you in the right direction. I think a multi-row tool to update the from date could do it. I chose this method in case there were any gaps.