Using concatenate that ignores blank cells and also includes line breaks

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!

Many thanks for the speedy response but that doesn't seem to work I still get the blank space where the blank cell is?

Hi, unfortunately that doesn't work as it doesn't ignore the blank cell and also removes the spaces within the address lines (e.g. 1 The Street becomes 1TheStreet) which I don't want.

Thanks - I tweaked it slightly to put a line break between the data in A2 and B2:

=A2&""&IF(B2="","",B2&CHAR(10))&IF(C2="","",C2&CHAR(10))&IF(D2="","",D2&CHAR(10))&IF(E2="","",E2&CHAR(10))

Pressing ALT + ENTER between the first set of "" and this has worked.

Thanks very much for your help.