On Sunday, January 13, 2013 11:28:20 PM UTC+2, wrote:
Add another column (B) and then add this function to fill in everything until another entry for the merged cell in col A:

=IF(A2=0,B1,A2).



This assumes you have one header.

For two or more rows, this will not work.