Snasui Excel Forum

Hi there

I have date in a column and text in next column.
I need formula to concat text from above cell till cell with date in adjacent cell.

I attach a template with expected results in colour cells.

Thanks

...

C2

=SUBSTITUTE(IF(A2="","",CONCAT($B$2:B2&",")),CONCAT(C$1:C1),"")

Norkaz

Another formula,

C2

=IF(A2="","",IFERROR(MID(CONCAT(","&B2:INDEX(B$2:B2,MATCH(2,1/INDEX(A$1:A1<>"",0)))),2,255),B2))

Enter and copy down.

Thank you both

snasui wrote: Mon Jul 11, 2022 11:45 am Another formula,

C2

=IF(A2="","",IFERROR(MID(CONCAT(","&B2:INDEX(B$2:B2,MATCH(2,1/INDEX(A$1:A1<>"",0)))),2,255),B2))

Enter and copy down.