excel filter not working on column

Lets say for instance that you have a worksheet in which each record actually consists of two rows and that the first column of t…