Concatenate / Textjoin based on certain criteria

[CA Rohit]

Hi All,

I have recently converted a pdf bank statement into an excel. However, few of the description has been split into two cells, resulting in extra line. I need a formula to combine the split cells into one cell based on date column. Attaching an excel sheet for reference.

I am thinking of using concatenate and offset, but struggling with the same.

TIA

 

[Juniad]

See the result in attached file with helper column. Hit Like if you find it useful.

 

[CA Rohit]

Thank you Juniad!!

 

[geo Jul]

See the result in attached file with helper column. Hit Like if you find it useful.

Dear Sir, I tried to use your clever formula in your sample (1) workbook I found if the date in Row 19 marked in yellow is duplicate the formula in cell F19 is not correct it's pulling the data from the above Cell F16 may I kindly request you to review the formula to accept duplicate dates your assistant is highly appreciated