Hello

i have merged four cells together (b24:b27) which contains the same store
name "b&Q". i have found that when merging cells, the data"b&Q" is only
recognised in the top cell "b24"

So when using autofilter, searching by store name "B&Q" it only brings
information up for row 24 and not all rows "24:27"

I dont want to have to type the same store name four times in each cell in
order for autofilter option to work properly.

Is there a way to do this using merged cells or any other solution?