Merging cells causes them to behave as one large single cell (along with fouling up sorting and other operations). Yet, you want the component cells of the merged range to be available for discrete values. It seems like you're working against Excel, instead of with it.

Perhaps if you describe the perceived need for merging, we could better understand what you're trying to do. It's very likely that there is an alternative to merging.