What I want is for the first two rows have their dates combined. I want to say that for ID 51376 the value was 1 from 12/30/2012 until 01/06/2013. If I use min/max, I'll also get the date from 1/13/2013.