Flaten values and keep low to high of other cells

[pctechtv]

If in a workbook I have a column of importance, in this case Animal. I have multiple Cats. I do not need all the Cat rows, I just need one with the lowest Start and the highest end. So, in this case my result would give me one row with Cat like so.

I want to do this for all of the Animals in my workbook. Thanks

 

[sheetspread]

The pivot table will do this