Excel 2007 : Skip a line at change in data

Hello,

I was wondering if there is a formula in excel that for every change in data in a particular column, you could skip a line.

For example, looking at a raw set of data, if a column title is "Vendor"; for every change in "Vendor" I would like to skip a row.

Thanks!