merlin_the_magician
Active Member
- Joined
- Jul 31, 2002
- Messages
- 480
Dumb question.....
In a workbook as displayed below, i have extracted some adresses from other loactions in the workbook.
i want to compress these adresses to a solid block (without the empty rows i mean) how do i fix this?
The empty rows may NOT be deleted!
In a workbook as displayed below, i have extracted some adresses from other loactions in the workbook.
i want to compress these adresses to a solid block (without the empty rows i mean) how do i fix this?
The empty rows may NOT be deleted!
Map1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | JenniferGreen | AbbeyRoad215 | London | |||
2 | ||||||
3 | ||||||
4 | ||||||
5 | JohnLocksley | LancasterAvenue25 | Cardiff | |||
6 | ||||||
7 | ||||||
8 | ||||||
9 | ||||||
10 | MichaelMcGregor | HalfwayRoad5 | MinsteronSea | |||
11 | ||||||
12 | ||||||
13 | ||||||
14 | ||||||
15 | LindaLeBlanc | CoventryStreet89 | London | |||
Blad1 |