Spreadsheet: 153259d1335832890-performing-pivot-like-calculations-without-the-use-of-the-pivot-table-and-parsing-out-list-sample
Sheet: Sheet1

PartNo | InventoryLocation | InventoryQuantity
017-M020 | FG | 0
017-M023 | FG | 0
[PHONE] | FG | 0
[PHONE] | FG | 6877
[PHONE] | FG | 643
[PHONE] | FG | 2631
[PHONE] | FG | 550
1123035-001 | FG | 687
1123051-001 | FG | 1509
1133001-006 | FG | 0
[PHONE] | FG | 0
5063180-001 | FG | 433
5080041-001 | FG | 66
5093145-001 | FG | 229
5093145-002 | FG | 176
5093159-001 | FG | 28
[PHONE] | FG | 9990
[PHONE] | FG | 9467
[PHONE] | FG | 9847
[PHONE] | FG | 9966
[PHONE] | FG | 9985
[PHONE] | FG | 4858
[PHONE] | FG | 4897
[PHONE] | FG | 2667
[PHONE] | FG | 28891
[PHONE] | FG | 9157
[PHONE] | FG | 8055
[PHONE] | FG | 9934
[PHONE] | FG | 2696
[PHONE] | FG | 9081
[PHONE] | FG | 9905
[PHONE] | FG | 9900
[PHONE] | FG | 9716
6025324-001 | FG | 12122
6025324-002 | FG | 6298
6025361-001 | FG | 4539
6025361-002 | FG | 4890
6025651-002 | FG | 6762
6025993-001 | FG | 9997
6026011-001 | FG | 30
6026012-001 | FG | 7137
6026175-001 | FG | 4004
6026240-001 | FG | 4469
6026252-001 | FG | 4297
6033025-001 | FG | 0
6033025-003 | FG | 0
6033029-003 | FG | 0
6045976 | FG | 0
6070026-001 | FG | 383
6070060-001 | FG | 645
6070067-001 | FG | 411
6070073-001 | FG | 2209
6070075-001 | FG | 282
[PHONE] | FG | 197
[PHONE] | FG | 1676
[PHONE] | FG | 0
[PHONE] | FG | 0
[PHONE] | FG | 908
7005324-001 | FG | 0
7005524-002 | FG | 0
7005534-001 | FG | 0
7005550-302 | FG | 0
7005558-301 | FG | 0
7005781-002 | FG | 0
7005794-006 | FG | 0
[PHONE] | FG | 0
[PHONE] | FG | 0
[PHONE] | FG | 0
[PHONE] | FG | 0
[PHONE] | FG | 0
[PHONE] | FG | 0
[PHONE] | FG | 478
[PHONE] | FG | 0
[PHONE] | FG | 0
[PHONE] | FG | 0
[PHONE] | FG | 0
[PHONE] | FG | 0
[PHONE] | FG | 5239
[PHONE] | FG | 0
[PHONE] | FG | 0
[PHONE] | FG | 0
[PHONE] | FG | 0
[PHONE] | FG | 0
[PHONE] | FG | 0
[PHONE] | FG | 0
[PHONE] | FG | 0
[PHONE] | FG | 0
[PHONE] | FG | 2516
[PHONE] | FG | 8
7095316-36J | FG | 0
7095316-37H | FG | 0
7095316-48J | FG | 562
7095316-49H | FG | 128
7095362-001 | FG | 0
7095412-001 | FG | 200
7095493-001 | FG | 10
7095493-003 | FG | 29
7095507-001 | FG | 148
7095513-002 | FG | 14
7095523-004 | FG | 0
7095544-001 | FG | 596
7095544-002 | FG | 1845
7095570-002U | FG | 47
7095585-011 | FG | 5
7095585-013 | FG | 34
7095652-001 | FG | 0
7095653-001 | FG | 5
7095761-001 | FG | 496
7095766-002 | FG | 0
7095821-001 | FG | 1092
7095835-001 | FG | 0
7095876-003 | FG | 0
[PHONE] | FG | 496
[PHONE] | FG | 439
[PHONE] | FG | 500
[PHONE] | FG | 26
[PHONE] | FG | 38
[PHONE] | FG | 38
[PHONE] | FG | 74
[PHONE] | FG | 42
[PHONE] | FG | 75
[PHONE] | FG | 345
[PHONE] | FG | 272
[PHONE] | FG | 275
[PHONE] | FG | 274
[PHONE] | FG | 2997
[PHONE] | FG | 289
[PHONE] | FG | 73
[PHONE] | FG | 888
[PHONE] | FG | 352
[PHONE] | FG | 2932
[PHONE] | FG | 1349
[PHONE] | FG | 781
[PHONE] | FG | 4079
[PHONE] | FG | 4079
[PHONE] | FG | 1987
[PHONE] | FG | 1987
[PHONE] | FG | 982
[PHONE] | FG | 1979
[PHONE] | FG | 979
9055015-001 | FG | 63
9055020-001 | FG | 108
9055040-002 | FG | 1300
9055049-001 | FG | 66
9055080-001 | FG | 321
9055081-001 | FG | 91
9055112-002 | FG | 539
9055121-001 | FG | 0
9055122-001 | FG | 309
9055142-001 | FG | 0
9055143-001 | FG | 335
9055172-001 | FG | 327
9055277-001 | FG | 231
9055489-001 | FG | 367
9055561-001 | FG | 471
9055845-001 | FG | 958
9196244-001 | FG | 182
9196299-001 | FG | 2460
AB-5301-00 | FG | 100
AB-5301-10 | FG | 277
AB-5411 | FG | 420
AB-5620 | FG | 704
AB-5620-002 | FG | 421
AB-5670 | FG | 0
AB-5675-70 | FG | 8
AB-6052CD | FG | 120
AB-6135 | FG | 88
AB-6500 | FG | 865
AB-6510 | FG | 104
AB-6521 | FG | 117
AB-6534 | FG | 422
AB-6535 | FG | 381
AB-7120 | FG | 40
AB-7200 | FG | 18
[NAME] | FG | 141
AB-7210 | FG | 174
AB-7250 | FG | 315
AB-7250LP | FG | 380
AB-7300 | FG | 748
AB-7300-001 | FG | 167
AB-7301-001 | FG | 55
AB-7301-002 | FG | 37
AB-7310 | FG | 32
AB-7420-01 | FG | 252
AB-7420-10 | FG | 93
AB-7420-35 | FG | 206
AB-7430-01 | FG | 109
AB-7430-15 | FG | 201
AB-7430-35 | FG | 205
AB-7430-36 | FG | 159
AB-7430-70 | FG | 435
AB-7440-26B | FG | 272
AB-7440-35B | FG | 83
AB-7440-35L | FG | 203
AB-7440-35R | FG | 157
AB-7440-36 | FG | 187
AB-7450-36 | FG | 80
AB-7500 | FG | 273
[PHONE] | RE | 0
[PHONE] | RE | 0
[PHONE] | RE | 0
1123035-001 | RE | 0
1123051-001 | RE | 0
5019212-003 | RE | 0
5063180-001 | RE | 0
5080041-001 | RE | 0
5093107-001 | RE | 0
5093143-001 | RE | 0
5093145-001 | RE | 0
5093159-001 | RE | 0
6015213-004 | RE | 0
[PHONE] | RE | 0
[PHONE] | RE | 0
[PHONE] | RE | 0
[PHONE] | RE | 0
[PHONE] | RE | 0
[PHONE] | RE | 0
[PHONE] | RE | 0
6025324-001 | RE | 0
6025651-002 | RE | 0
6026011-001 | RE | 0
6033025-001 | RE | 0
6033025-003 | RE | 0
6033027-003 | RE | 0
6033029-003 | RE | 0
6045622-002 | RE | 0
6070026-001 | RE | 0
6070053-001 | RE | 0
6070060-001 | RE | 0
6070067-001 | RE | 0
6070073-001 | RE | 0
6070075-001 | RE | 0
[PHONE] | RE | 0
[PHONE] | RE | 0
7005545-002 | RE | 0
7005550-302 | RE | 0
7005558-301 | RE | 0
[PHONE] | RE | 0
[PHONE] | RE | 0
[PHONE] | RE | 0
[PHONE] | RE | 0
[PHONE] | RE | 0
7095316-009 | RE | 0
7095316-012 | RE | 0
7095316-014 | RE | 0
7095316-021 | RE | 0
7095316-026 | RE | 0
7095316-36J | RE | 0
7095316-37H | RE | 0
7095316-48J | RE | 24
7095316-49H | RE | 3
7095324-001 | RE | 0
7095339-001 | RE | 0
7095349-001 | RE | 0
7095475-TST | RE | 0
7095507-001 | RE | 0
7095513-002 | RE | 0
7095544-001 | RE | 0
7095544-002 | RE | 0
7095546-001 | RE | 0
7095546-002 | RE | 0
7095570-002U | RE | 0
7095585-001 | RE | 0
7095585-002 | RE | 0
7095585-003 | RE | 0
7095585-004 | RE | 0
7095585-005 | RE | 0
7095585-006 | RE | 0
7095585-008 | RE | 0
7095585-009 | RE | 0
7095585-011 | RE | 0
7095585-013 | RE | 1
7095639-001 | RE | 0
7095640-001 | RE | 0
7095661-001 | RE | 0
7095661-002 | RE | 0
7095682-001 | RE | 0
7095757-001 | RE | 0
7095757-002 | RE | 0
7095757-003 | RE | 0
7095758-001 | RE | 0
7095758-002 | RE | 0
7095758-003 | RE | 0
7095761-001 | RE | 1
7095766-002 | RE | 0
7095821-001 | RE | 0
[PHONE] | RE | 0
[PHONE] | RE | 0
[PHONE] | RE | 0
[PHONE] | RE | 0
[PHONE] | RE | 0
[PHONE] | RE | 0
[PHONE] | RE | 0
[PHONE] | RE | 0
[PHONE] | RE | 0
9055040-002 | RE | 0
9055080-001 | RE | 0
9055142-001 | RE | 0
9055172-001 | RE | 0
9055277-001 | RE | 0
9055489-001 | RE | 0
9055561-001 | RE | 0
9055565-001 | RE | 0
9055576-001 | RE | 0
9055845-001 | RE | 0
9196244-001 | RE | 0
9196299-001 | RE | 0
AB-5100H | RE | 0
AB-5100H-01A | RE | 0
AB-5100H-11 | RE | 0
AB-5100H-11A | RE | 0
AB-5100H-12 | RE | 0
AB-5100H-12A | RE | 0
AB-5100L | RE | 0
AB-5100R | RE | 0
AB-5200 | RE | 0
[NAME] | RE | 0
AB-5301-00 | RE | 0
AB-5301-10 | RE | 0
AB-5321B | RE | 0
AB-5411 | RE | 0
AB-5500 | RE | 0
AB-5620 | RE | 0
AB-5620-002 | RE | 2
AB-6052CD | RE | 0
AB-6500 | RE | 1
AB-6510 | RE | 0
AB-6521 | RE | 0
AB-6531 | RE | 0
AB-6532 | RE | 0
AB-6534 | RE | 0
AB-6535 | RE | 0
AB-7100 | RE | 0
AB-7200 | RE | 0
[NAME] | RE | 0
AB-7250 | RE | 0
AB-7250LP | RE | 0
AB-7300 | RE | 0
AB-7300-001 | RE | 0
AB-7420-01 | RE | 0
AB-7430-01 | RE | 0
AB-7430-15 | RE | 0
AB-7430-36 | RE | 0
AB-7430-70 | RE | 0
AB-7440-26B | RE | 0
AB-7440-35B | RE | 0
AB-7440-35R | RE | 0
AB-7450-36 | RE | 0
AB-7500 | RE | 0
[PHONE] | SK | 0
[PHONE] | SK | 0
[PHONE] | SK | 0
1123035-001 | SK | 0
1123051-001 | SK | 0
5019212-003 | SK | 0
5063180-001 | SK | 0
5080041-001 | SK | 0
5093107-001 | SK | 0
5093143-001 | SK | 0
5093145-001 | SK | 0
5093159-001 | SK | 0
6015213-004 | SK | 0
[PHONE] | SK | 0
[PHONE] | SK | 0
[PHONE] | SK | 0
[PHONE] | SK | 0
[PHONE] | SK | 0
[PHONE] | SK | 0
[PHONE] | SK | 0
6025324-001 | SK | 0
6025651-002 | SK | 0
6026011-001 | SK | 0
6033025-001 | SK | 0
6033025-003 | SK | 0
6033027-003 | SK | 0
6033029-003 | SK | 0
6045622-002 | SK | 0
6070026-001 | SK | 0
6070053-001 | SK | 0
6070060-001 | SK | 0
6070067-001 | SK | 0
6070073-001 | SK | 0
6070075-001 | SK | 0
[PHONE] | SK | 0
[PHONE] | SK | 0
7005545-002 | SK | 0
7005550-302 | SK | 0
7005558-301 | SK | 0
[PHONE] | SK | 0
[PHONE] | SK | 0
[PHONE] | SK | 0
[PHONE] | SK | 0
[PHONE] | SK | 0
7095316-009 | SK | 0
7095316-012 | SK | 0
7095316-014 | SK | 0
7095316-021 | SK | 0
7095316-026 | SK | 0
7095316-36J | SK | 0
7095316-37H | SK | 0
7095316-48J | SK | 24
7095316-49H | SK | 3
7095324-001 | SK | 0
7095339-001 | SK | 0
7095349-001 | SK | 0
7095475-TST | SK | 0
7095507-001 | SK | 0
7095513-002 | SK | 0
7095544-001 | SK | 0
7095544-002 | SK | 0
7095546-001 | SK | 0
7095546-002 | SK | 0
7095570-002U | SK | 0
7095585-001 | SK | 0
7095585-002 | SK | 0
7095585-003 | SK | 0
7095585-004 | SK | 0
7095585-005 | SK | 0
7095585-006 | SK | 0
7095585-008 | SK | 0
7095585-009 | SK | 0
7095585-011 | SK | 0
7095585-013 | SK | 1
7095639-001 | SK | 0
7095640-001 | SK | 0
7095661-001 | SK | 0
7095661-002 | SK | 0
7095682-001 | SK | 0
7095757-001 | SK | 0
7095757-002 | SK | 0
7095757-003 | SK | 0
7095758-001 | SK | 0
7095758-002 | SK | 0
7095758-003 | SK | 0
7095761-001 | SK | 1
7095766-002 | SK | 0
7095821-001 | SK | 0