I have used the same basic approach (font colour=background colour) before and find it much simpler that resorting to pivot tables. A suggestion to those who (rightly) point out that the cells look empty: Instead of effectiely blanking the duplciate cells, just choose a lighter font colour (light grey instead of black, for example). This gives the required prominence to rows where the date has changed without hiding the data completely.