You have a number of address fields which you want to CONCATENATE into one field but you want the address information to appear on different lines after concatenation.
1 | A | B | C | D |
2 | Address 1 | Address 2 | Address 3 | Address 1 Address 2 Address 3 |
In the above example you would insert the following formula in Cell D2;
=ArrayFormula( CONCATENATE( A2& CHAR(10),B2& CHAR(10),C2 ) )