Cathmac801
New Member
- Joined
- Apr 23, 2014
- Messages
- 20
Hi all
I have addresses in col A as follows
Person 1
Address line 1
Address line 2
City
Country
BLANK ROW
Person 2
Address line 1
Address line 2
Addres line 3
City
Country
BLANK ROW
etc
How do I get them to show up as
Person 1 Address line1 Address line 2 City Country
Person 2 Address line 1 Address line 2 Address line 3 City Country
Each person has numerous lines but each complete address has a blank row between it and the next address
thanks a mil
Cath
I have addresses in col A as follows
Person 1
Address line 1
Address line 2
City
Country
BLANK ROW
Person 2
Address line 1
Address line 2
Addres line 3
City
Country
BLANK ROW
etc
How do I get them to show up as
Person 1 Address line1 Address line 2 City Country
Person 2 Address line 1 Address line 2 Address line 3 City Country
Each person has numerous lines but each complete address has a blank row between it and the next address
thanks a mil
Cath