Merging content of 2 cells to one cell

Copper Contributor

christian2100_0-1593612004288.png

 

Hi all,

I need some help.

Hope someone can help?

 

kind regards Christian, Denmark

 

 

6 Replies

@christian2100 

That could be

image.png

with

 

=INDEX(A:A,ROW()*2-1)&CHAR(10)&INDEX(A:A,ROW()*2)

 

Don't forget to apply Wrap text to resulting cells

@Sergei Baklan 

 

Hi Sergei 

 

Thanks for your answer.

I dont know what I am doing wrong I am pasting the formular in fx line.

But i doesn´t work for me?

christian2100_0-1593671154858.png

Br Christian

 

 

Hi @christian2100,

it looks like your Excel is in Danish. If yes, then you should translate the formula to danish - what implies on one hand the translation of the function names and on another hand the use of the list separator of your system (usually ; instead of a comma)

 

=INDEKS(A:A;RÆKKE()*2-1)&TEGN(10)&INDEKS(A:A;RÆKKE()*2)

 

Best,

Mourad

@Sergei Baklan 

 

Hi Sergei

 

Thanks so much for your help.

Much appreciated.

It now works when I got the formula translated into Danish.

 

Br Christian,Copenhagen Denmark

@Mourad Louha 

 

Thanks so much, you solved the problem.

Br Christian

@christian2100 

Christian, glad to help.

@Mourad Louha , thank you