Missing dates

Hi All,

I have a table with many missing dates.

For example in this table I have missing date for id 1 and id 2. 

id

Start_Date

End_Date

1

1/2/00

4/5/04

1

7/9/06

3/4/09

1

9/10/10

1

1/5/12

4/5/15

1

9/6/16

12/12/18

2

1/2/97

2/7/01

2

3/5/05

4/3/07

9/2/14

2

5/1/19

I am basically interested in the last date for each id.

For id ‘I’  have a Start_Date (2016) corresponding to the End_Year(2018) for the the last date

but in the case of ID ‘2’ I do not have it(it is NULL). In that case I would like to choose the earlier non null date (4/3/2007) for the Start_Date.

So my desired output would be as

id

Start_Year

End_Year

1

9/6/16

12/12/18

2

4/3/07

5/1/19

I used Fixed(id): Max(Start_Date)} to get the Max Start_Date for each id, however I am not getting the desired result.

I have attached the sample worksheet for your kind reference. 

Any advise would be helpful. 

Regards

Rishi Saka