I have effective and expiration dates in a dataset where I have transposed them so all for the key I have created are in a single row in the dataset. I want to be able to compare all of the dates to see if there is a break in the dates. My end result should be if I can combine the dates in the row to make one effective date and one expiration date. I can't use MIN(Eff_Dt) or MAX(Exp_Dt) because I might miss breaks in the dates. I have attached a few examples in an excel spreadsheet.
... View more