Jul 01 2020 06:53 AM - edited Jul 01 2020 07:02 AM
Hi all,
I need some help.
Hope someone can help?
kind regards Christian, Denmark
Jul 01 2020 07:08 AM - edited Jul 01 2020 07:09 AM
That could be
with
=INDEX(A:A,ROW()*2-1)&CHAR(10)&INDEX(A:A,ROW()*2)
Don't forget to apply Wrap text to resulting cells
Jul 01 2020 11:26 PM
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?
Br Christian
Jul 02 2020 12:19 AM
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
Jul 02 2020 01:22 AM
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
Jul 02 2020 06:56 AM
Jul 02 2020 01:15 PM