I have a field of 30 lines by 3 columns. Based on other data on the
page none of the lines may have data while as many as 30 of the lines
may have data. the data all flows into other areas and into charts.

I need a way even if it means importing the data in to another
worksheet or cells, to condense the data to eliminate the blank lines
WITHOUT running a macro.

Example: I need:

A B C D
1 17642 1 78.44% TOTAL SALARIES & BENEFITS
2 468 4 2.08% 31 SUPPLIES
3
4 32 7 0.14% 33 SUPPLIES-ISSUED FROM INVENTORY
5 1160 3 5.16% 34 SERVICES
6
7
8
9
10
11
12
13 56 6 0.25% 3D TRAVEL OTHER THAN TRAINING
14
15
16
17 2692 2 11.97% 3H VEHICLE MAINTENANCE SERVICES
18
19 29 8 0.13% 3K CARFARE & TOLLS
20
21
22
23
24
25 411 5 1.83% 42 UTILITIES & HEATING FUEL
26
27
28
29
30


To turn into:

A B C D
1 17642 1 78.44% TOTAL SALARIES & BENEFITS
2 468 4 2.08% 31 SUPPLIES
3 32 7 0.14% 33 SUPPLIES-ISSUED FROM INVENTORY
4 1160 3 5.16% 34 SERVICES
5 56 6 0.25% 3D TRAVEL OTHER THAN TRAINING
6 2692 2 11.97% 3H VEHICLE MAINTENANCE SERVICES
7 29 8 0.13% 3K CARFARE & TOLLS
8 411 5 1.83% 42 UTILITIES & HEATING FUEL


I need this to occur automatically because it has to function for
novice users that won't even know how to do a sort.