Paste values from single cells to partly merged and unmerged cells in excel

[akalien]

Hi,

I have

How can I paste values from single cells in one column to partly merged and unmerged cells in an other column.

I tried this formula =INDEX($M$2:$M$705;COUNTA(L$2:L2)) but it doesn't work due to the fact that I've got merged cells and as well unmerged cells in the same column.

Any ideas

Many thanks in advance

 

[Marc L]

Hi,​

​

as Excel does not need to merge cells so obviously unmerge cells and use the cell formatting 'Center across columns' in the Horizontal Alignment …​