Hi guys,

I've searched and searched and not been able to come up with an answer. If I have information as below:

Add_1: 19 Smith Road
Add_2: Holyroyd
Add_3:
Add_4: Chorlston
Add_5:
Add_6: MK12RR

Can you tell me how I merge it so it suppresses blanks and shows as follows:

19 Smith Road
Holyroyd
Chorlston
MK12RR

Thus removing any blanks and making everything look nice and neat. I've been messing around with If statements but can only seem to get one of those - for example If address 2 is blank then print address 3 but this doesn't shift everything else up.

Any suggestions?