putting values next to a merged cell

[zazzz]

i have a few thousand cells that are merged into a few hundred cells.

for the sake of filtering i'd like to put the values of these cells into independent cells. i want to know if there's a way to do that, preferably by formula not by vbasic?

to clarify:

i have A1:A100 merged into one cell, A101:A200 merged into one, etc. I'd like the value of the first cell to be put into each of the cells from B1:B100, and then have the next merged cell, A101-200, put into B101-200 etc. Can this be done?

[ChemistB]

In B1 enter what ever you have in A1
In B2 dragged down
=IF(ISBLANK(A2),B1,A2)
Does that work for you?