1. You could add a formula in an unused column (say, B). Then in B2, enter and copy down,
=IF(A2<>A1, 1, "")
2. Select that column, and do Edit > Go to > Special, Formula, and check Numbers
3. Insert > Rows
4. Delete or clear the temporary column
Bookmarks