Spreadsheet: 874138d1720708979-combine-filter-with-multiple-sort-on-alphabetical-numercial-order-yeti2201-stock-overview-test-sheet
Sheet: Stock - sorted overview

Lot | Cask number | Location | Supplier | Product | length | category | Original quantity | Current quantity | Category Ranking |  |  |  |  |  |  | Lot | Cask number | Location | Supplier | Product | length | category | [NAME] | Make-up | Original quantity | Current quantity
 | 61302 | Wharehouse 1 | A | P.A. | 18/20 | 10+ | 900 | 900 | 1 |  |  |  | Sort sequence |  |  |  |  | Wharehouse 1 | A | P.A. | 19/21 | 10+
0003 | 61303 | Wharehouse 1 | A | P.A. | 18/20 | 10+ | 900 | 900 | 1 |  |  | 1 | Wharehouse 1 / Wharehouse 2 |  |  |  |  | Wharehouse 1 | A | P.A. | 20/22 | 10+
5694 | 35000080-026 | Wharehouse 1 | A | P.A. | 24/26 | 10+ | 800 | 800 | 1 |  |  | 2 | Supplier - Alphabatically |  |  |  |  | Wharehouse 1 | A | P.A. | 22/24 | 10+
5718 | 39690944-031 | Wharehouse 1 | A | P.C. | 19/21 | 7-10 | 500 | 500 | 4 |  |  | 3 | Product - Alphabatically |  |  |  |  | Wharehouse 1 | A | P.C | 19/21 | 7-10
5726 | 1936392-009 | Wharehouse 1 | A | P.H. | 33/36 | 8+ | 270 | 270 | 2 |  |  | 4 | Length - small to large |  |  |  |  | Wharehouse 1 | A | P.C | 20/22 | 7-10
5726 | 1936392-010 | Wharehouse 1 | A | P.H. | 33/36 | 8+ | 270 | 270 | 2 |  |  | 5 | Category large to small |  |  |  |  | Wharehouse 1 | A | P.C | 22/24
5726 | 1936392-011 | Wharehouse 1 | A | P.H. | 33/36 | 8+ | 270 | 270 | 2 |  |  |  |  |  |  |  |  | Wharehouse 1 | B
5726 | 1936392-012 | Wharehouse 1 | A | P.H. | 33/36 | 8+ | 270 | 270 | 2 |  |  |  |  |  |  |  |  | Wharehouse 1 | B
5726 | 1936392-013 | Wharehouse 1 | A | P.H. | 33/36 | 8+ | 270 | 270 | 2 |  |  |  |  |  |  |  |  | Wharehouse 1 | B
5726 | 1936392-014 | Wharehouse 1 | A | P.H. | 33/36 | 8+ | 270 | 270 | 2 |  |  |  |  |  |  |  |  | Wharehouse 1 | B
5734 | 1943307-011 | Wharehouse 1 | A | P.H. | 33/36 | 8+ | 270 | 270 | 2 |  |  |  |  |  |  |  |  | Wharehouse 1 | B
5734 | 1943307-012 | Wharehouse 1 | A | P.H. | 33/36 | 8+ | 270 | 270 | 2 |  |  |  |  |  |  |  |  | Wharehouse 1 | B
5711 | 3426-08-24 00:00:00 | Wharehouse 1 | B | P.A. | 19/21 | 10+ | 700 | 700 | 1 |  |  |  |  |  |  |  |  | Wharehouse 1 | B
5714 | 3426-10-16 00:00:00 | Wharehouse 1 | B | P.A. | 19/21 | 10+ | 700 | 700 | 1 |  |  |  |  |  |  |  |  | Wharehouse 1 | B
0006-2 | 557907 | Wharehouse 1 | B | P.A. | 19/21 | 10+ | 700 | 700 | 1 |  |  |  |  |  |  |  |  | Wharehouse 2 | etc
0006-2 | 557908 | Wharehouse 1 | B | P.A. | 19/21 | 10+ | 700 | 700 | 1
0006-3 | 557909 | Wharehouse 1 | B | P.A. | 20/22 | 10+ | 700 | 700 | 1
0006-3 | 557910 | Wharehouse 1 | B | P.A. | 20/22 | 10+ | 700 | 700 | 1
0006-3 | 557911 | Wharehouse 1 | B | P.A. | 20/22 | 10+ | 700 | 700 | 1
0006-3 | 557912 | Wharehouse 1 | B | P.A. | 20/22 | 10+ | 700 | 700 | 1
0002 | 557862 | Wharehouse 1 | B | P.A. | 21/23 | 10+ | 700 | 700 | 1
0006-4 | 557915 | Wharehouse 1 | B | P.A. | 21/23 | 10+ | 700 | 700 | 1
0006-4 | 557916 | Wharehouse 1 | B | P.A. | 21/23 | 10+ | 700 | 700 | 1
5721 | 3427-02-12 00:00:00 | Wharehouse 1 | B | P.A. | 22/24 | 10+ | 700 | 700 | 1
5721 | 3427-02-13 00:00:00 | Wharehouse 1 | B | P.A. | 22/24 | 10+ | 700 | 700 | 1
5730 | 3427-03-11 00:00:00 | Wharehouse 1 | B | P.A. | 22/24 | 10+ | 700 | 700 | 1
5730 | 3427-03-12 00:00:00 | Wharehouse 1 | B | P.A. | 22/24 | 10+ | 700 | 700 | 1
5731 | 81372-2 | Wharehouse 1 | B | P.C. | 20/22 | 7-10 | 700 | 700 | 4
0001 | 45000315-001 | Wharehouse 2 | A | P.A. | 18/20 | 10+ | 900 | 900 | 1
0003 | 61301 | Wharehouse 2 | A | P.A. | 18/20 | 10+ | 900 | 900 | 1
0007-1 | 66401 | Wharehouse 2 | A | P.A. | 19/21 | 10+ | 900 | 900 | 1
0007-1 | 66402 | Wharehouse 2 | A | P.A. | 19/21 | 10+ | 900 | 900 | 1
0007-1 | 66403 | Wharehouse 2 | A | P.A. | 19/21 | 10+ | 900 | 900 | 1
0007-1 | 66404 | Wharehouse 2 | A | P.A. | 19/21 | 10+ | 900 | 900 | 1
0001 | 45000315-008 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 900 | 1
0001 | 45000315-015 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 900 | 1
0001 | 45000315-017 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 580 | 1
0003 | 61307 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 900 | 1
0003 | 61308 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 900 | 1
0003 | 61309 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 900 | 1
0003 | 61310 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 900 | 1
0003 | 61311 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 900 | 1
0003 | 61312 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 900 | 1
0003 | 61313 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 900 | 1
0003 | 61314 | Wharehouse 2 | A | P.A. | 20/22 | 10+ | 900 | 900 | 1
0007-2 | 66405 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 820 | 1
0007-2 | 66406 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 820 | 1
0007-2 | 66407 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 820 | 1
0007-2 | 66408 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 820 | 1
0007-2 | 66409 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 820 | 1
0007-2 | 66410 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 820 | 1
0007-3 | 66411 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 820 | 1
0007-3 | 66412 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 820 | 1
0007-3 | 66413 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 820 | 1
0007-3 | 66414 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 820 | 1
0007-3 | 66415 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 820 | 1
0007-3 | 66416 | Wharehouse 2 | A | P.A. | 22/24 | 10+ | 820 | 400 | 1
5694 | 35000080-024 | Wharehouse 2 | A | P.A. | 24/26 | 10+ | 372 | 228 | 1
5694 | 35000080-025 | Wharehouse 2 | A | P.A. | 24/26 | 10+ | 800 | 800 | 1
5630 | 19690363-049 | Wharehouse 2 | A | P.C. | 19/21 | 7-10 | 384 | 184 | 4
0004 | 61333 | Wharehouse 2 | A | P.C. | 20/22 | 10+ | 500 | 360 | 1
0004 | 61334 | Wharehouse 2 | A | P.C. | 20/22 | 10+ | 500 | 500 | 1
0004 | 61336 | Wharehouse 2 | A | P.C. | 20/22 | 10+ | 500 | 500 | 1
0004 | 61337 | Wharehouse 2 | A | P.C. | 20/22 | 10+ | 500 | 500 | 1
0004 | 61339 | Wharehouse 2 | A | P.C. | 22/24 | 7-10 | 500 | 500
0004 | 61340 | Wharehouse 2 | A | P.C. | 22/24 | 7-10 | 500 | 500
5734 | 1943307-004 | Wharehouse 2 | A | P.H. | 33/36 | 8+ | 270 | 270 | 2
5734 | 1943307-005 | Wharehouse 2 | A | P.H. | 33/36 | 8+ | 270 | 51 | 2
5734 | 1943307-006 | Wharehouse 2 | A | P.H. | 33/36 | 8+ | 270 | 270 | 2
5734 | 1943307-009 | Wharehouse 2 | A | P.H. | 33/36 | 8+ | 270 | 270 | 2
5637 | 1924927-002 | Wharehouse 2 | A | P.H. | 43/46 | 8+ | 204 | 144 | 2
5733 | 3427-03-18 00:00:00 | Wharehouse 2 | B | P.A. | 18/20 | 10+ | 700 | 380 | 1
0006-1 | 557906 | Wharehouse 2 | B | P.A. | 18/20 | 10+ | 700 | 700 | 1
5714 | 557649 | Wharehouse 2 | B | P.A. | 19/21 | 10+ | 700 | 500 | 1
5733 | 3427-03-19 00:00:00 | Wharehouse 2 | B | P.A. | 19/21 | 7-14 | 600 | 400 | 3
5733 | 3427-03-22 00:00:00 | Wharehouse 2 | B | P.A. | 20/22 | 10+ | 700 | 368 | 1
0002 | 3427-05-13 00:00:00 | Wharehouse 2 | B | P.A. | 20/22 | 10+ | 700 | 700 | 1
0002 | 3427-05-14 00:00:00 | Wharehouse 2 | B | P.A. | 20/22 | 10+ | 700 | 700 | 1
0002 | 3427-05-15 00:00:00 | Wharehouse 2 | B | P.A. | 20/22 | 10+ | 700 | 700 | 1
0002 | 3427-05-12 00:00:00 | Wharehouse 2 | B | P.A. | 20/22 | 7-10 | 700 | 700 | 4
0006-4 | 557913 | Wharehouse 2 | B | P.A. | 21/23 | 10+ | 700 | 700 | 1
0006-4 | 557914 | Wharehouse 2 | B | P.A. | 21/23 | 10+ | 700 | 700 | 1
5716 | 3426-11-07 00:00:00 | Wharehouse 2 | B | P.A. | 21/23 | 7-10 | 528 | 200 | 4
5716 | 557676 | Wharehouse 2 | B | P.A. | 22/24 | 10+ | 224 | 24 | 1
5719 | 3426-12-26 00:00:00 | Wharehouse 2 | B | P.A. | 22/24 | 10+ | 700 | 700 | 1
5703 | 3426-06-16 00:00:00 | Wharehouse 2 | B | P.A. | 22/24 | 7-10 | 480 | 380 | 4
0005 | 83984-3 | Wharehouse 2 | B | P.C. | 20/22 | 10+ | 700 | 700 | 1
0005 | 83984-5 | Wharehouse 2 | B | P.C. | 20/22 | 10+ | 700 | 700 | 1
0005 | 83984-7 | Wharehouse 2 | B | P.C. | 20/22 | 10+ | 700 | 700 | 1
0005 | 83984-8 | Wharehouse 2 | B | P.C. | 20/22 | 10+ | 700 | 700 | 1
0005 | 83984-9 | Wharehouse 2 | B | P.C. | 20/22 | 10+ | 700 | 700 | 1
0005 | 83984-10 | Wharehouse 2 | B | P.C. | 20/22 | 10+ | 700 | 700 | 1
5731 | 81372-1 | Wharehouse 2 | B | P.C. | 20/22 | 7-10 | 700 | 700 | 4