How to set the next End date to todays date based on color in last row

[#1]

Hi,

I have this in data, I am going to use this in a interval match, but the problem is, I want that if the last record Color is yellow there should be a new Start date based on the Start date in the last row!  and set the End date as todays date.

Se example

Current data, wished outcome in (Red)

Name	Start	End	Color	Group
Thomas	2012-05-29	2013-11-07	Green	5
Thomas	2011-06-08	2012-05-29	Yellow	3
Thomas	2015-05-08	2016-07-05	Yellow	6
Thomas	2016-07-05	Date(Today)	Yellow	6