Idea for merging a selection of multiple cells with multiple values
I tried to merge a selection of multiple cells with multiple values and got:
"When merging cells, only one cell can contain a value. The current selection contains multiple cells with values and cannot be merged."
Instead, my suggestion is to give the user an option to select one of the selected cells with the value that the user would like to be applied to the merged cell.