Spreadsheet: 692269d1598248145-retrieve-data-based-on-qty-greater-than-zero-in-multiple-columns-test-file
Sheet: Input Qty

 |  |  |  |  |  |  |  |  | Storage1 | Storage1 | Storage2 | Storage2 | Storage3 | Storage3 | Storage4 | Storage4 | Storage5 | Storage5
S.N. | Vendor | Item Code | Item Description | UOM | Packaging | Unit Cost | Total Qty. | Total Cost | Qty. | Value | Qty. | Value | Qty. | Value | Qty. | Value | Qty. | Value
1 | Vendor1 | AA1100009777 | ID 1 | EACH | 4 Ltr | 437 |  |  |  |  |  |  |  |  | 1
2 | Vendor1 | AA1100009778 | ID 2 | EACH | 4 Ltr | 437
3 | Vendor1 | AA1100009779 | ID 3 | EACH | 4 Ltr | 437 |  |  | 3
4 | Vendor1 | AA1100009780 | ID 4 | EACH | 4 Ltr | 265 |  |  |  |  | 11
5 | Vendor1 | AA1100009781 | ID 5 | EACH | 4 Ltr | 175 |  |  |  |  |  |  | 4
6 | Vendor1 | AA1100010888 | ID 6 | EACH | 20 [NAME] | 700 |  |  | 5
7 | Vendor1 | AA1100012127 | ID 7 | EACH | 4 Ltr | 160 |  |  |  |  | 12 |  |  |  | 11
8 | Vendor1 | AA1100012128 | ID 8 | EACH | 20 [NAME] | 630
9 | Vendor1 | AA1100009782 | ID 9 | EACH | 800 Ltr | 46 |  |  |  |  |  |  |  |  |  |  | 25
10 | Vendor1 | AA1100010070 | ID 10 | EACH | 20 [NAME] | 220
11 | Vendor1 | AA1100011488 | ID 11 | EACH | 20 [NAME] | 400
12 | Vendor1 | AA1100013263 | ID 12 | EACH | 4 Ltr | 220 |  |  |  |  | 9 |  |  |  |  |  | 33
13 | Vendor1 | AA1100011607 | ID 13 | EACH | 4 Ltr | 437 |  |  |  |  |  |  |  |  | 9
14 | Vendor1 | AA1100011489 | ID 14 | EACH | 20 [NAME] | 500
T
1 | Vendor2 | AA1100008109 | ID 16 | CARTON | [NAME] pcs | 215
2 | Vendor2 | AA1100013546 | ID 17 | CARTON | Pkt x 4 | 180
3 | Vendor2 | AA1100013547 | ID 18 | EACH | 400 ML | 29
4 | Vendor2 | AA1100016658 | ID 19 | EACH | Each | 11.5
5 | Vendor2 | AA1100016660 | ID 20 | EACH | Each | 11.5
6 | Vendor2 | AA1100016661 | ID 21 | EACH | Each | 11.5
7 | Vendor2 | AA1100016662 | ID 22 | EACH | Each | 11.5
8 | Vendor2 | AA1100016663 | ID 23 | EACH | Each | 11.5
9 | Vendor2 | AA1100016664 | ID 24 | EACH | Each | 11.5
10 | Vendor2 | AA1100016665 | ID 25 | EACH | Each | 11.5
11 | Vendor2 | AA1100016666 | ID 26 | EACH | Each | 11.5
12 | Vendor2 | AA1100016667 | ID 27 | EACH | Each | 11.5
13 | Vendor2 | AA1100016668 | ID 28 | EACH | Each | 11.5
14 | Vendor2 | AA1100016669 | ID 29 | EACH | Each | 11.5
15 | Vendor2 | AA1100016670 | ID 30 | EACH | Each | 11.5
16 | Vendor2 | AA1100016671 | ID 31 | EACH | Each | 11.5
17 | Vendor2 | AA1100016672 | ID 32 | EACH | Each | 11.5
18 | Vendor2 | AA1100016673 | ID 33 | EACH | Each | 11.5
19 | Vendor2 | AA1100016674 | ID 34 | EACH | Each | 11.5
20 | Vendor2 | AA1100016675 | ID 35 | EACH | Each | 11.5
21 | Vendor2 | AA1100016676 | ID 36 | EACH | Each | 11.5
22 | Vendor2 | AA1100000934 | ID 37 | BUNDLE | 20 kg per bundle | 112
23 | Vendor2 | AA1100000935 | ID 38 | BUNDLE | 20 kg per bundle | 112
24 | Vendor2 | AA1100012484 | ID 39 | BUNDLE | 20 kg per bundle | 112
25 | Vendor2 | AA1100009605 | ID 40 | BUNDLE | 20 kg per bundle | 112
T
1 | Vendor3 | AA1100011917 | ID 42 | CARTON | 4 cans x 5 liters | 60
2 | Vendor3 | AA1100011910 | ID 43 | CARTON | 1 pack x 6 x 140 M | 48
3 | Vendor3 | AA1100008047 | ID 44 | CARTON | Carton x 20 Pkt | 38
4 | Vendor3 | AA1100011914 | ID 45 | CARTON | Carton x 30 Each | 45
5 | Vendor3 | AA1100011915 | ID 46 | CARTON | 1 carton x 30 boxes | 39
6 | Vendor3 | AA1100009597 | ID 47 | CARTON | 1 carton x 30 boxes | 38
7 | Vendor3 | AA1100011912 | ID 48 | CARTON | carton x 12 Rolls | 37
8 | Vendor3 | AA1100012524 | ID 49 | CARTON | Carton x 100 Rolls | 98
9 | Vendor3 | AA1100011913 | ID 50 | CARTON | Carton x 100 Rolls | 75
T
1 | Vendor4 | AA1100013534 | ID 52 | CARTON | 6 pouches x 800ml | 152.25
2 | Vendor4 | AA1100013536 | ID 53 | CARTON | 2 x 5 liters | 68
3 | Vendor4 | AA1100013545 | ID 54 | CARTON | 6 pouches x 800ml | 242
4 | Vendor4 | AA1100000030 | ID 55 | CARTON | 2 bottles x 5 liters | 77.25
T
1 | Vendor5 | AA1100013586 | ID 57 | EACH | Box (1x50) | 2.75
2 | Vendor5 | AA1100015252 | ID 58 | EACH | 1 x 100 pc | 9.75
3 | Vendor5 | AA1100013588 | ID 59 | CARTON | 1 x 12 | 10.8
4 | Vendor5 | AA1100013589 | ID 60 | CARTON | 1 x 12 | 10.8
T
1 | Vendor6 | AA1100013597 | ID 62 | CARTON | 15Pkt/Car | 38.5
2 | Vendor6 | AA1100013544 | ID 63 | CARTON | 6Ro/Car | 45
3 | Vendor6 | AA1100010504 | ID 64 | CARTON | 100P/Car | 72.5
4 | Vendor6 | AA1100013535 | ID 65 | CARTON | 4 x 5Ltr/Carton | 55
5 | Vendor6 | AA1100015390 | ID 66 | CARTON | 36Pc/Car | 39
6 | Vendor6 | AA1100009763 | ID 67 | CARTON | 1 x 6 Rolls | 37
7 | Vendor6 | AA1100008031 | ID 68 | CARTON | 1x12rolls | 35.5
T
1 | Vendor7 | AA1100015376 | ID 70 | EACH | 10 Ltr | 175.2
2 | Vendor7 | AA1100015377 | ID 71 | EACH | 10 Ltr | 162.5
3 | Vendor7 | AA1100015378 | ID 72 | EACH | 10 Ltr | 143
4 | Vendor7 | AA1100015379 | ID 73 | EACH | 10 Ltr | 441
5 | Vendor7 | AA1100015380 | ID 74 | EACH | 10 Ltr | 180
6 | Vendor7 | AA1100015381 | ID 75 | EACH | 10 Ltr | 185
7 | Vendor7 | AA1100015382 | ID 76 | EACH | 1 Ltr | 48
8 | Vendor7 | AA1100015383 | ID 77 | EACH | 200 ML | 43.4
9 | Vendor7 | AA1100015384 | ID 78 | EACH | 600 ML | 52.2
10 | Vendor7 | AA1100015385 | ID 79 | EACH | 200 ML | 69
11 | Vendor7 | AA1100015386 | ID 80 | EACH | 600 ML | 54.5
12 | Vendor7 | AA1100015387 | ID 81 | EACH | 10 Ltr | 242.7
13 | Vendor7 | AA1100015388 | ID 82 | EACH | 10 Ltr | 218.4
14 | Vendor7 | AA1100016371 | ID 83 | EACH | 10 Ltr | 95
15 | Vendor7 | AA1100017076 | ID 84 | EACH | 10 Ltr | 441.8 | 0
T |  |  | Total Per Site
 |  |  |  |  |  |  | Grand Total