Page 1 of 1
text concatenation
Posted: Fri Apr 08, 2022 10:04 pm
by sna
Hi there!
I need your expert help to combine the lines in column B at each change in the date in column A, with a formula in Column C.
I attach a sample
Thank you
Re: text concatenation
Posted: Sun Apr 10, 2022 10:39 pm
by sna
I need to concat text until it reaches another date.the expected result in column C
Thank you
Re: text concatenation
Posted: Sun Apr 10, 2022 10:47 pm
by norkaz
...
Excel 2019
C2
=CONCAT(IF(LOOKUP(ROW($A$2:$A$20),ROW($A$2:$A$20)/($A$2:$A$20<>""))=ROW(A2),$B$2:$B$20&" ",""))
Ctrl + Shift +Enter
or
=TEXTJOIN(" ",1,IF(LOOKUP(ROW($A$2:$A$20),ROW($A$2:$A$20)/($A$2:$A$20<>""))=ROW(A2),$B$2:$B$20,""))
Ctrl + Shift +Enter
Norkaz
Re: text concatenation
Posted: Sun Apr 10, 2022 10:59 pm
by sna
Thank you it is working