auto filter in merged cells

[Guest]

I put autofilter on for example column A which has merged cells(A1+A2 , A3+A4
, ...).when I use autofilter on it excell just filter the first rows of the
selected item.for example if I use autofilter and select a number which is in
merged cell(A1+A2)it just show the information in rows 1 and don't show info
in rows 2.How can I solve this?

 

[Dave Peterson]

I do this.

First, get rid of the merged cells.

The fill each of the "bottom" cells with the value of the cell above.

Debra Dalgleish shows how to do this using formulas:
http://www.contextures.com/xlDataEntry02.html

Then hide the bottom rows by using format|conditional formatting (make it white
font on white fill).

Debra shows this, too:
http://www.contextures.com/xlCondFormat03.html#Duplicate