code needed....please

[jvoortman]

I have a list of information running down column A.
Unfortunately, The company name is seperated from the rest
of that company's data by an empty cell. Then the next
company and it's info are a lot of blank cells below. What
I would like is to take out the blank between the company
and it's corresponding address information. Alos, take out
all the blanks EXCEPT ONE betwen the different companies
and their information. Here is a example of what the raw
data looks like. The "borders' are there just to show the
cells, and does not occur in document. There is a example
of what I need it to look like in the end. I did smll
amount manually just to show what I'm looking for. All
help is greatly appreciated.

 

[jvoortman]

sample before:

M P S Metro Automotive & Industrial Products 613-728-
3778

1580 Laperriere Avenue,
Ottawa, ON
K1Z 7T2











G A Automobile Inc 819-539-6471

9682, boulevard des Hêtres,
Shawinigan, QC
G9N 4Y3











Peinture-O-Max Inc 418-667-7766

386A, rue Seigneuriale,
Beauport, QC
G1C 3P9











Rond-Point Dodge & Chrysler Ltée 450-656-4110

5055 Cousineau,
Saint-Lambert, QC








Autos Coloris 450-444-7722

100 Rg St Joseph,
Saint-Philippe, QC
J0L 2K0










Car System Distribution Inc 514-745-5959

1399, rue Saint-Amour,
Saint-Laurent, QC
H4S 1T4










Carrosserie Réal Blouin 819-821-4788

4376, boulevard Bourque,
Rock Forest, QC
J1N 1S3










Centre de Collision Spécialisé 450-433-2232

14413 Bd Curé Labelle,
Mirabel, QC
J7J 1M2










Centre de Collision Spécialisé 450-433-2232

14413 Bd Curé Labelle,
St-Janvier, QC
J7J 1M2










Custeau Peinture Inc 418-338-0336

2040, rue Notre-Dame Nord,
Thetford Mines, QC
G6G 2W2










Custeau Peinture Inc 418-683-2227

1375, boulevard Charest Ouest,
Québec, QC
G1N 2E7










Custeau Peinture Inc 819-348-0021

1060, 12E avenue Nord,
Fleurimont, QC
J1E 2X3










Fix Auto Ste-Agathe 819-321-2480

1159, rue Principale Est,
Sainte-Agathe-des-Monts, QC
J8C 1L7










Lévis Mazda 418-837-8897

5095, rue Louis-H.-La Fontaine,
Lévis, QC
G6V 8X4










Service Auto H D Inc 418-687-2906

500, boulevard Père-Lelièvre,
Vanier, QC
G1M 1N4




sample after:

M P S Metro Automotive & Industrial Products 613-728-
3778
1580 Laperriere Avenue,
Ottawa, ON
K1Z 7T2

G A Automobile Inc 819-539-6471
9682, boulevard des Hêtres,
Shawinigan, QC
G9N 4Y3

Peinture-O-Max Inc 418-667-7766
386A, rue Seigneuriale,
Beauport, QC
G1C 3P9

Rond-Point Dodge & Chrysler Ltée 450-656-4110
5055 Cousineau,
Saint-Lambert, QC

Autos Coloris 450-444-7722
100 Rg St Joseph,
Saint-Philippe, QC
J0L 2K0

Car System Distribution Inc 514-745-5959
1399, rue Saint-Amour,
Saint-Laurent, QC
H4S 1T4

Carrosserie Réal Blouin 819-821-4788
4376, boulevard Bourque,
Rock Forest, QC
J1N 1S3

Centre de Collision Spécialisé 450-433-2232
14413 Bd Curé Labelle,
Mirabel, QC
J7J 1M2

Centre de Collision Spécialisé 450-433-2232
14413 Bd Curé Labelle,
St-Janvier, QC
J7J 1M2

Custeau Peinture Inc 418-338-0336
2040, rue Notre-Dame Nord,
Thetford Mines, QC
G6G 2W2

Custeau Peinture Inc 418-683-2227
1375, boulevard Charest Ouest,
Québec, QC
G1N 2E7

Custeau Peinture Inc 819-348-0021
1060, 12E avenue Nord,
Fleurimont, QC
J1E 2X3

Fix Auto Ste-Agathe 819-321-2480
1159, rue Principale Est,
Sainte-Agathe-des-Monts, QC
J8C 1L7

Lévis Mazda 418-837-8897
5095, rue Louis-H.-La Fontaine,
Lévis, QC
G6V 8X4

Service Auto H D Inc 418-687-2906
500, boulevard Père-Lelièvre,
Vanier, QC
G1M 1N4

Viau Réal Inc 450-373-5482
46, rue Saint-Thomas,
Salaberry-de-Valleyfield, QC
J6T 4J3

(FD) Gilles Daigle Inc Autotraction 418-563-0242
301 Route 132, QC
G0R 4J0

A S Carrosseries 819-377-7199
880 Notre Dame,
Pointe-du-Lac, QC
G0X 1Z0

Arslan Automotive Canada Ltd 514-694-1113
84, avenue Leacock,
Pointe-Claire, QC
H9R 1H1

Artisan Carrossier Enr 450-448-2992
5855, Place de la Savane,
Saint-Hubert, QC
J3Y 8Y9

Auto En Gros 514-351-5700
4255, rue Paul-Pau,
Montréal, QC
H1K 2M5

Autos Ali 514-747-0746
2620, rue Brabant-Marineau,
Saint-Laurent, QC
H4S 1L1

Brown H E Supply 705-474-1310
161 Lakeshore Drive,
North Bay, ON
P1A 2B2

Carosseries Lambert Inc 450-445-0311
2790, rue Star,
Saint-Hubert, QC
J3Y 3W6

Carquest Vanier (Peinture) 418-681-6650
35 rue Beaucage,
Vanier, QC
G1M 3L4

Carrosserie A & J 450-656-4144
5485, rue de Kensington,
Saint-Hubert, QC
J3Y 2W7

Carrosserie Besner 450-968-3258
4791, boulevard Laurier,
La Plaine, QC
J7M 1C3

Carrosserie Idéale Int St-Léonard Inc 514-259-1444
8075, boulevard Langelier,
Saint-Léonard, QC
H1P 2B7

Carrosserie Ti-Ben 450-565-1038
1500, boulevard des Hauteurs,
Sainte-Sophie, QC
J5J 2L4

Chambre A Peinture A G 450-656-4915
4435, avenue Thibault,
Saint-Hubert, QC
J3Y 7N1