Good morning!
I have five columns: Name / Address 1 / Address 2 / Address 3 / Address 4
I would like to concatenate them into one cell, but with a line break between item, the result being:
Name
Address 1
Address 2
Address 3
Address 4
in the same cell
I am able to do the above where there is data in all cells but where one of the cells (eg Address 3) is blank it returns the following:
Name
Address 1
Address 2
Address 4
Whereas I want it to show:
Name
Address 1
Address 2
Address 4
All help gratefully received!
Bookmarks