Spreadsheet: 715979d1611942874-combine-multiple-tables-some-blank-rows-into-master-table-combining-tables
Sheet: Sheet1

Master |  |  |  |  |  |  | table 1 |  |  |  |  |  |  |  |  | table 2 |  |  |  |  |  |  |  |  | table 3
Item # | Item Description | Quantity | Cost Ea. | Total | P.O. # |  | Item # | Memo | Item | Item Description | Quantity | Cost | Total | PO # |  | Item # | Memo | Item | Item Description | Quantity | Cost | Total | PO # |  | Item # | Memo | Item | Item Description | Quantity | Cost | Total | PO #
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 6 FIBER LC/UPS 900UM PIGTAIL, SM, BLUE | [NAME] (6 FIBER LC/UPS 900UM PIGTAIL, SM, BLUE) | 6 FIBER LC/UPS 900UM PIGTAIL, SM, BLUE | 8 | 14.6 | 116.8 | 39358 |  | SIEMS700A110B150 | SIEMON S110 50 PR PREWIRED BLOCK | SIEMS700A110B150 (SIEMON S110 50 PR PREWIRED BLOCK) | SIEMON S110 50 PR PREWIRED BLOCK | 10 | 118.6 | 1186 | 39355
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FISSSP12LCMM50GAQ | FIBER INSTRUMENTS 12 FIBER 900UM MM 50UM 0M3 AQUA PIGTAIL | FISSSP12LCMM50GAQ (FIBER INSTRUMENTS 12 FIBER 900UM MM 50UM 0M3 AQUA PIGTAIL) | FIBER INSTRUMENTS 12 FIBER 900UM MM 50UM 0M3 AQUA PIGTAIL | 8 | 21.76 | 174.08 | 39358 |  | ALLE253PC20GY | ALLENTEL 25 PR M/F 20FT AMPHENOL | ALLE253PC20GY (ALLENTEL 25 PR M/F 20FT AMPHENOL) | ALLENTEL 25 PR M/F 20FT AMPHENOL | 20 | 26.93 | 538.6 | 39355
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LEVI4108W-ISP | [NAME] | LEVI4108W-ISP (LEVITON CAT5E SSWALL PHONE PLATE) | [NAME] | 10 | 8.36 | 83.6 | 39355
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ORTOR808004042 | ORTRONIC 48P 2/8, 25M,V,SPS PP | ORTOR808004042 (ORTRONIC 48P 2/8, 25M,V,SPS PP) | ORTRONIC 48P 2/8, 25M,V,SPS PP | 10 | 167.24 | 1672.4 | 39355
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LEVI5G108BO5 | [NAME], ORANGE, 25 PACK | LEVI5G108BO5 (LEVITON CAT5E, ORANGE, 25 PACK) | [NAME], ORANGE, 25 PACK | 16 | 72.5 | 1160 | 39355
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LEVI15G108B15 | [NAME], [NAME], 25 PACK | LEVI15G108B15 (LEVITON CAT5E, [NAME], 25 PACK) | [NAME], [NAME], 25 PACK | 14 | 72.5 | 1015 | 39355
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LEVI492RUHFO | LEVITON 2RU HORIZ WIRE MANAGER | LEVI492RUHFO (LEVITON 2RU HORIZ WIRE MANAGER) | LEVITON 2RU HORIZ WIRE MANAGER | 16 | 28.1 | 449.6 | 39355
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LEVIG596U24 | [NAME], 24P PATCH PANEL | [NAME] (LEVITON CAT5E, 24P PATCH PANEL) | [NAME], 24P PATCH PANEL | 25 | 102.03 | 2550.75 | 39355
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LEVI41080-3IP | LEVITON WP QP 3PORT SG IVORY | LEVI41080-3IP (LEVITON WP QP 3PORT SG IVORY) | LEVITON WP QP 3PORT SG IVORY | 85 | 1.961 | 166.69 | 39355
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | LEVITON 1PORT SURFACE MOUNT IVY | [NAME] (LEVITON 1PORT SURFACE MOUNT IVY) | LEVITON 1PORT SURFACE MOUNT IVY | 170 | 1.44 | 244.8 | 39355
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LEVI141084-FIF | LEVITON F TYPE MODULE | LEVI141084-FIF (LEVITON F TYPE MODULE) | LEVITON F TYPE MODULE | 600 | 1.49 | 894 | 39355
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BELDSNS-1P6 | BELDEN SNS 1 PC F MALE 6 SERIES (100 PK) | BELDSNS-1P6 (BELDEN SNS 1 PC F MALE 6 SERIES (100 PK)) | BELDEN SNS 1 PC F MALE 6 SERIES (100 PK) | 6 | 64.11 | 384.66 | 39355
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LEVI41084-BIB | LEVITON IVORY BLANKS FOR FACEPLATES  , BAG OF TEN | LEVI41084-BIB (LEVITON IVORY BLANKS FOR FACEPLATES) | LEVITON IVORY BLANKS FOR FACEPLATES | 50 | 1.892 | 94.6 | 39355