Counting non identical columns

Could anyone explain how to count how many, or remove  non-identical entries there are in a set of columns?   e.g. In this table, in lines 1- 4 column A and B are identical, but lines 5 - 9, column...