Spreadsheet: 111154d1307610937-excel-2007-deleting-the-empty-row-sample3
Sheet: Sales Analysis

SWITCH FOOD STUFF TRADING L.L.C
CHKN190 | 532.8 | 5
D01626D
JF706899 |  |  |  | in this report I need to delet the entire row if any cell is empty in colomn A
CLEGQ005 | 14800 | 200
D01643D
JF706883
MTTN007 | 3729.6 | 15
 | 15 | 207.2
JF706901
CLEGQ005 | 7400 | 100
 | 100 | 100
 | 115 | 307.2
D01659D
JF706898
CLEGQ005 | 7400 | 100
 | 100 | 100
 | 100 | 100
D01673D
8774
CHKN024 | 0
CHKN050 | 0
SH308653
CHKN219 | 5250 | 50
 | 50 | 600
 | 50 | 600
[NAME]
JF706900
CLEGQ005 | 7400 | 100
 | 100 | 100
 | 100 | 100
D01689D
JF706885
MTTN007 | 7511.4 | 30
 | 30 | 417.3
 | 30 | 417.3
D01692D
SH308660
CLEGQ005 | 14800 | 200
 | 200 | 200
 | 200 | 200
D01711D
SH308636
[NAME] | 3150 | 25
 | 25 | 375
SH308638
[NAME] | 3150 | 25
 | 25 | 375
 | 50 | 750
D01723D
[NAME]
PRO055 | 100 | 1
 | 1 | 1
 | 1 | 1
D01736D
JF706868
CHKN050 | 3480 | 40
CHKN105 | 1840 | 25
CHKN205 | 1848 | 20
CHKN206 | 1968 | 20
CHKN207 | 1053 | 10
 | 115 | 1190
SH308627
VLEG001 | 2592 | 10
 | 10 | 180
 | 125 | 1370
D01763D
SH308629
CHKN050 | 865 | 10
 | 10 | 100
 | 10 | 100
D01767D
JF706871
CHKN205 | 1452 | 15
 | 15 | 165
 | 15 | 165
D01781D
JF706873
CHKN050 | 1305 | 15
CHKN205 | 1386 | 15
 | 30 | 315
 | 30 | 315
D01802D
JF706867
CHKN205 | 2310 | 25
 | 25 | 275
 | 25 | 275
D01803D
VA2059
BOBYV005 | 364 | 2
CHKN024 | 1494 | 15
CHKN054 | 602 | 5
CHKN203 | 810 | 10
CLEGQ003 | 148 | 2
 | 34 | 344
 | 34 | 344
D01809D
8783
CHKN205 | 0
PK550105
CBREST014 | 2362.5 | 15
 | 15 | 225
 | 15 | 225
D01857D
8764
CBREST014 | 0
CLIVER004 | 0
8765
CLIVER012 | 0
8766
CLIVER004 | 0
8767
CLIVER004 | 0
PK550104
CBREST014 | 68692.5 | 426
CLIVER004 | 19180 | 400
 | 826 | 9990
 | 826 | 9990
D01879D
SH308661
CLEGQ005 | 7400 | 100
 | 100 | 100
 | 100 | 100
D01908D
JF706869
CBREST016 | 315 | 2
VEG046 | 164 | 4
 | 6 | 34
 | 6 | 34
D01913D
[NAME]
CHKN219 | 1512 | 15
 | 15 | 180
 | 15 | 180
D01924D
SH308632
CHKN204 | 190 | 2
VEG046 | 84 | 2
 | 4 | 22
 | 4 | 22
D01926D
SH308652
CHKN203 | 2193.75 | 25
 | 25 | 225
 | 25 | 225
[NAME]
JF706896
CLEGQ005 | 7500 | 100
 | 100 | 100
 | 100 | 100
D01935D
8787
CHKN024 | 0
[NAME]
JF706884
CLEGQ005 | 190791.12 | 3120
 | 3120 | 3120
SH308644
CLEGQ005 | 95395.56 | 1560
 | 1560 | 1560
 | 4680 | 4680
D01949D
SH308659
CLEGQ005 | 7400 | 100
 | 100 | 100
 | 100 | 100
D01950D
JF706878
CHKN203 | 2430 | 30
 | 30 | 270
SH308625
CHKN203 | 1215 | 15
 | 15 | 135
 | 45 | 405
[NAME]
SH308637
CFRANK007 | 21200 | 400
 | 400 | 400
 | 400 | 400
[NAME]
SH308613
BOBYV011 | 370 | 2
CFRANK001 | 300 | 5
CHKN023 | 4199 | 38
VEG002 | 276 | 6
 | 51 | 507
 | 51 | 507
D01974D
SH308614
CHKN203 | 2025 | 25
 | 25 | 225
 | 25 | 225
D01976D
8785
CHEES001 | 0
D01977D
[NAME]
CLEG005 | 2880 | 20
 | 20 | 20
 | 20 | 20
D01988D
JF706886
PRO003 | 281.25 | 3
PRO004 | 307.56 | 3
PRO005 | 337.5 | 3
PRO051 | 67.5 | 1
PRO053 | 108 | 1
PRO054 | 71.25 | 1
 | 12 | 110
JF706888
PRO0124 | 144 | 1
PRO0125 | 180 | 1
PRO122 | 153 | 1
PRO123 | 180 | 1
 | 4 | 4
 | 16 | 114
D02015D
JF706897
CLEGQ005 | 7400 | 100
 | 100 | 100
 | 100 | 100
D02016D
8769
CDSTICK011 | 0
CLIVER004 | 0
JF706864
CGIZARD001 | 900 | 20
CHKN193 | 6380 | 55
 | 75 | 900
SH308655
CLEGQ005 | 7400 | 100
 | 100 | 100
 | 175 | 1000
D02034D
8782
PRO005 | 0
D02036D
8780
PRO111 | 0
PRO112 | 0
PRO113 | 0
PRO114 | 0
D02038D
SH308664
CLEGQ005 | 7400 | 100
VEG046 | 430 | 10
 | 110 | 110
 | 110 | 110
D02055D
8770
CHKN050 | 0
D02063D
8771
CWING012 | 0
D02069D
8778
PRO051 | 0
PRO052 | 0
PRO053 | 0
PRO054 | 0
PRO058 | 0
D02072D
8777
PAS002 | 0
PAS005 | 0
JF706893
CDSTICK011 | 210 | 2
CGIZARD001 | 180 | 2
CHKN054 | 138.6 | 1
CHKN064 | 158.4 | 2
CLIVER004 | 170 | 2
 | 9 | 52
 | 9 | 52
D02074D
JF706890
PAS002 | 135 | 3
PAS003 | 135 | 3
PAS004 | 135 | 3
PAS006 | 135 | 3
PRO003 | 468.75 | 5
PRO004 | 512.6 | 5
PRO005 | 562.5 | 5
PRO051 | 337.5 | 5
PRO054 | 356.25 | 5
PRO111 | 185 | 5
PRO112 | 185 | 5
PRO114 | 185 | 5
 | 52 | 242
 | 52 | 242
D02080D
8786
CHKN205 | 0
MOZRELA001 | 0
VLEG001 | 0
D02081D
JF706887
PRO003 | 187.5 | 2
PRO004 | 205.04 | 2
PRO055 | 300 | 3
 | 7 | 45
 | 7 | 45
D02085D
8781
PRO004 | 0
PRO051 | 0
JF706870
CHKN064 | 808 | 10
PRO003 | 1900 | 20
PRO004 | 1045 | 10
PRO005 | 570 | 5
PRO051 | 135 | 2
PRO053 | 216 | 2
PRO054 | 142.5 | 2
 | 51 | 472
JF706882
CHKN064 | 1616 | 20
 | 20 | 160
SH308649
CHKN203 | 454.5 | 5
 | 5 | 45
SH308650
CHKN056 | 454.5 | 5
 | 5 | 45
SH308651
CHKN056 | 454.5 | 5
 | 5 | 45
 | 86 | 767
D02095D
8779
CHKN024 | 0
D02100D
8776
PRO054 | 0
JF706889
CWING012 | 128.2 | 1
PAS003 | 42.6 | 1
PAS005 | 85.2 | 2
PAS006 | 42.6 | 1
PRO003 | 937.5 | 10
PRO004 | 1025.2 | 10
PRO005 | 562.5 | 5
PRO051 | 135 | 2
 | 32 | 293
 | 32 | 293
D02102D
JF706891
BOBYV005 | 200 | 1
CHKN060 | 409.5 | 3
CHKN096 | 380.25 | 3
PRO005 | 562.5 | 5
PRO055 | 100 | 1
PRO058 | 166.5 | 3
VEG018 | 55 | 1
VEG037 | 50 | 1
VLEAVE001 | 120 | 1
 | 19 | 149
JF706892
PRO0124 | 144 | 1
PRO0125 | 180 | 1
PRO122 | 153 | 1
PRO123 | 180 | 1
 | 4 | 4
 | 23 | 153
D05005D
SH308662
CLEGQ005 | 14800 | 200
 | 200 | 200
SH308663
CLEGQ005 | 3700 | 50
 | 50 | 50
 | 250 | 250
D05009D
JF706881
CHKN202 | 1850 | 25
CHKN203 | 2025 | 25
CHKN204 | 2162.5 | 25
CHKN205 | 2310 | 25
CHKN206 | 2460 | 25
 | 125 | 1250
 | 125 | 1250
D05014D
JF706879
CHKN105 | 3312 | 45
 | 45 | 360
SH308641
CGIZARD003 | 450 | 10
CHKN203 | 8100 | 100
 | 110 | 910
 | 155 | 1270
D05134D
SH308634
CBREST014 | 517.5 | 3
CHKN050 | 4550 | 50
CLIVER004 | 100.01 | 2
 | 55 | 563
 | 55 | 563
D05167D
SH308654
LAMBCUT010 | 9250.8 | 25
 | 25 | 462.54
 | 25 | 462.54
D05173D
8790
CHKN190 | 0
CHKN220 | 0
D05176D
8772
VEG046 | 0
JF706895
MTTN007 | 7725.6 | 30
 | 30 | 417.6
 | 30 | 417.6
D05179D
SH308624
CHKN205 | 184.8 | 2
 | 2 | 22
 | 2 | 22
D05202D
SH308645
CHKN205 | 9515 | 100
 | 100 | 1100
 | 100 | 1100
D05215D
VB26893
CHKN203 | 163.8 | 2
CHKN205 | 277.2 | 3
 | 5 | 51
 | 5 | 51
D05220D
VB26892
BOBYV003 | 208 | 1
CHKN204 | 435 | 5
 | 6 | 51
 | 6 | 51
D05221D
SH308617
BFMINCE007 | 75 | 1
CHKN205 | 369.6 | 4
 | 5 | 45
 | 5 | 45
D05233D
SH308616
CHKN023 | 315.9 | 3
CHKN205 | 280.5 | 3
 | 6 | 72
 | 6 | 72
D05237D
SH308635
CHKN023 | 526.5 | 5
CHKN205 | 935 | 10
 | 15 | 175
 | 15 | 175
D05240D
VB26896
CHKN050 | 870 | 10
 | 10 | 100
 | 10 | 100
D05242D
VB26897
BOBYV004 | 1880 | 10
CHKN023 | 2080 | 20
 | 30 | 270
 | 30 | 270
D05246D
VB26894
CFRANK001 | 54 | 1
VEG002 | 126 | 3
 | 4 | 4
 | 4 | 4
D05255D
SH308630
CHKN205 | 2772 | 30
 | 30 | 330
 | 30 | 330
D05259D
SH308626
CHKN205 | 935 | 10
 | 10 | 110
 | 10 | 110
D05271D
SH308623
CHKN206 | 2460 | 25
 | 25 | 300
 | 25 | 300
D05273D
SH308639
LAMB022 | 999 | 2
 | 2 | 44.4
 | 2 | 44.4
D05306D
SH308633
CBREST014 | 157.5 | 1
CHKN023 | 536.25 | 5
 | 6 | 80
 | 6 | 80
D05330D
SH308619
BOBYV005 | 4500 | 25
 | 25 | 25
 | 25 | 25
D05380D
VB26895
CHKN204 | 435 | 5
 | 5 | 50
 | 5 | 50
D05398D
JF706865
CWING010 | 120 | 1
 | 1 | 1
SH308615
CHKN208 | 588 | 5
 | 5 | 70
 | 6 | 71
D05412D
SH308621
CLIVER004 | 1225.12 | 25
 | 25 | 225
 | 25 | 225
D05429D
SH308611
CHKN023 | 421.2 | 4
VEG035 | 75 | 1
 | 5 | 53
 | 5 | 53
D05441D
SH308622
BOBYV005 | 1780 | 10
 | 10 | 10
 | 10 | 10
D05454D
JF706880
CHKN105 | 2208 | 30
 | 30 | 240
SH308640
CFRANK001 | 550 | 10
CHKN203 | 4050 | 50
 | 60 | 460
 | 90 | 700
D05544D
8788
CHKN050 | 0
SH308643
CHKN050 | 4275 | 50
CHKN205 | 2772 | 30
CHKN206 | 2445 | 25
 | 105 | 1130
 | 105 | 1130
D05560D
SH308665
CLEGQ005 | 7400 | 100
 | 100 | 100
 | 100 | 100
D05576D
SH308628
CHKN050 | 17100 | 200
 | 200 | 2000
 | 200 | 2000
[NAME]
SH308620
CFRANK002 | 371 | 7
CLIVER004 | 92.02 | 2
 | 9 | 25
SH308642
CDSTICK011 | 105 | 1
CHKN206 | 100 | 1
 | 2 | 13
SH308647
CHKN054 | 2408 | 20
 | 20 | 280
SH308648
CHKN202 | 64 | 2
CHKN208 | 112 | 2
 | 4 | 44
 | 35 | 362
 | 787830.01 | 10308