I need to use the Autofilter on the first column of data. However, each cell
in the first column is actually two cells (two rows merged), and it is not
filtering properly. e.g.

1962 Jane Doe 13 15 27
Hired xxxx 4 7 10
1974 John Smith 27 15 30
Hired xxxx 12 7 10

As you can see, there are two rows of data for each entry in the first
column. When I use Autofilter I only get the top line of data. How can I
change it so I get both rows of data when filtering on the first column?