How to concatenate two row data in particular column

[supermanPunch (Arpan)]

Hi @Raja.G ,

Do we also have a case where there would be two blank cells continuously ?

If so, do we need to concatenate both the blank space corresponding values to the previous rows ?