Autofilter in Excel

[JsiPxi]

Because I have merged some cells over 2 rows, when I try and autofilter them,
only half the row of data comes up. How can I stop this from happening?

 

[Dave Peterson]

Remove the merged cells and put the value in each row???

If you want to try, then visit Debra Dalgleish's site for a way to fill empty
cells from the value in the cell above.

http://contextures.com/xlDataEntry02.html