Merge Cells Data with Multiple rows or New Lines

*I hope to have a formula that can concatenate A and B columns but each texts within cells shall still sit next to each other.

Ideal Result in Column D

Here is the sheet:

>Solution :



enter image description here

Leave a Reply