I am sorry, but I am confused. Are there grey and white or not? You said no, then started talking about the grey and white. As I see it, rows 1 to 18 have the same date in columns A, B, C. Do you wan t those emerged, jsut columns A, B, C?

Why not give a before and after example covering all possibilties, with the data as it really looks.