Hi All,
hope you are good, first i need a help to copy merge cell value and paste in another location column H without spaces ( merge cell ).
second in column C i want to paste column A names to Column C merge cell. i select Column C ( c1 to c18 ) range then use formula =INDEX($A$1:$A$5,COUNTA(C$1:C1)) Ctrl +Enter result is ZERO.
file is attached
Thanks
Bookmarks