Spreadsheet: 110396d1307059800-finding-data-in-a-table-and-appending-it-to-a-cell-copy-of-sample-printers
Sheet: Printer Inventory 0511

Printer ID | IP Address | acsc.cics | acsc.vps | Model | acsc.print.server | acsc.prod.id | Incidents/Printer | Incident | Row | Incident | Row | Incident | Row | Incident |  | Incident Rows
C01L | x.x.x.x | C01P | U30001 | HP LaserJet 8150 | SA0PRINT02 | CXXXXA | 0 |  |  |  |  |  |  |  |  | 229
[NAME] | x.x.x.x | C00P | U30000 | HP LaserJet 9000 MFP | SA0PRINT02 | Q2458A | 0
A21L | x.x.x.x | A21P | U1002 | HP LaserJet 9000 MFP | SA0PRINT01 | Q2458A | 2 | IM4064499 | 4 | IM4067254 | 5
A04L | x.x.x.x | A04P | U10004 | HP LaserJet 9000 MFP | SA0PRINT01 | Q2458A | 0
A20L | x.x.x.x | A20P | U10020 | HP LaserJet 9000 MFP | SA0PRINT01 | Q2458A | 0
E04L | x.x.x.x | E04P | U11004 | HP LaserJet 9000 MFP | SA0PRINT03 | Q2458A | 0
A25L | x.x.x.x | A25P | U10025 | HP LaserJet 9000 MFP | SA0PRINT01 | Q2458A | 0
B13L | x.x.x.x | B13P | U20013 | HP LaserJet 4200 | SA0PRINT01 | Q2428A | 0
F46L | x.x.x.x | F46P | U24046 | HP LaserJet 4200 | SA0PRINT03 | Q2428A | 0
C12L | x.x.x.x | C12P | U30012 | HP LaserJet 4200 | SA0PRINT02 | Q2426A | 0
A19L | x.x.x.x | A19P | U10019 | HP LaserJet 9000 MFP | SA0PRINT01 | Q2458A | 0
D24L | x.x.x.x | D24P | U40024 | HP LaserJet 9000 MFP | SA0PRINT02 | Q2458A | 1 | IM4064379 | 17
B08L | x.x.x.x | B08P | U20008 | HP LaserJet 9000 MFP | SA0PRINT01 | Q2458A | 0
F66L | x.x.x.x |  |  | HP LaserJet 4250 | SA0PRINT03 | Q5403A | 0
C40L | x.x.x.x |  |  | HP LaserJet 9050 | SA0PRINT02 | Q3722A | 0
C04L | x.x.x.x | C04P | U30004 | HP LaserJet 4200 | SA0PRINT02 | Q2426A | 1 | IM4058010 | 10
F51L | x.x.x.x |  |  | HP LaserJet 4250 | SA0PRINT03 | Q5403A | 0
G03L | x.x.x.x | G03P | U31003 | HP LaserJet 9000 MFP | SA0PRINT04 | Q2458A | 1 | IM4060860 | 25
TH8B | x.x.x.x | TH8B | U58002 | HP LaserJet 9050 MFP | ST0PRINT101 | Q3728A | 2 | IM4066797 | 226 | IM4068242 | 227
B11L | x.x.x.x | B11P | U20011 | HP LaserJet 4200 | SA0PRINT01 | Q2428A | 0
B04L | x.x.x.x | B04P | U20004 | HP LaserJet 4200 | SA0PRINT01 | Q2428A | 0
D13L | x.x.x.x | D13P | U40013 | HP LaserJet 4200 | SA0PRINT02 | Q2426A | 0
F34L | x.x.x.x |  |  | HP LaserJet 9000 MFP | SA0PRINT03 | Q2458A | 0
B01L | x.x.x.x | B01P | U20001 | HP LaserJet 9000 MFP | SA0PRINT01 | Q2458A | 0
G01L | x.x.x.x | [NAME] | U31001 | HP LaserJet 8150 | SA0PRINT04 | CXXXXA | 0
[NAME] | x.x.x.x | [NAME] | U56014 | HP LaserJet 9000 MFP | ST0PRINT101 | Q2458A | 0
PRN78-15 | x.x.x.x | CMEP | U47814 | HP LaserJet 4050 | DO78PRINT100 | CXXXXA | 0
E26L | x.x.x.x | [NAME] |  | HP LaserJet 9000 MFP | SA0PRINT03 | Q2458A | 0
B41L | x.x.x.x |  |  | HP LaserJet 9000 MFP | SA0PRINT01 | Q2458A | 0
E06L | x.x.x.x | E06L | U11008 | HP LaserJet 9000 MFP | SA0PRINT03 | Q2458A | 0
A06L | x.x.x.x | A06P | U10006 | HP LaserJet 9000 MFP | SA0PRINT01 | Q2458A | 1 | IM4062611 | 3
F48L | x.x.x.x |  |  | HP LaserJet 4250 | SA0PRINT03 | Q5403A | 0
H01L | x.x.x.x | H01P | U41001 | HP LaserJet 9000 MFP | SA0PRINT04 | CXXXXA | 0
E03L | x.x.x.x |  |  | HP LaserJet 4200 | SA0PRINT03 | Q2426A | 0
PRN49-15 | x.x.x.x | ES7C | U34907 | HP LaserJet 4050 | DO49PRINT100 | CXXXXA | 0
TH7B | x.x.x.x | TH7B | U57002 | HP LaserJet 9000 MFP | ST0PRINT101 | Q2458A | 0
B20L | x.x.x.x | B20P |  | HP LaserJet 4100 | SA0PRINT01 | C8051A | 0
PRN4-10 | x.x.x.x | LB1L | U40403 | HP LaserJet 9000 MFP | DO4MEM01 | Q2458A | 0
A26L | x.x.x.x | A26P | U10026 | HP LaserJet 4200 | SA0PRINT01 | Q2426A | 0
TH6B | x.x.x.x | TH6B | U56002 | HP LaserJet 9000 MFP | ST0PRINT101 | Q2458A | 1 | IM4065451 | 224
C36L | x.x.x.x | C36P | U32006 | HP LaserJet 9000 MFP | SA0PRINT02 | Q2458A | 3 | IM4058998 | 12 | IM4062530 | 13 | IM4066763 | 14 |  |  |  |  | IM4066763
TH7G | x.x.x.x | TH7G | U57007 | HP LaserJet 9000 MFP | ST0PRINT101 | Q2458A | 0
G21L | x.x.x.x | G21P | U31021 | HP LaserJet 9000 MFP | SA0PRINT04 | Q2458A | 0
PRN45-10 | x.x.x.x | BURH | U44508 | HP LaserJet 9000 MFP | DO45MEM100 | Q2458A | 0
PRN4-22 | x.x.x.x | LB0L | U30400 | HP LaserJet 9000 MFP | DO4MEM01 | Q2458A | 1 | IM4063664 | 144
G06L | x.x.x.x | G06P | U31006 | HP LaserJet 8150 | SA0PRINT04 | CXXXXA | 0
F58L | x.x.x.x |  |  | HP LaserJet 9000 MFP | SAOPRINT03 | CXXXXA | 3 | IM4067758 | 22 | IM4068521 | 23 | IM4069451 | 24
F45L | x.x.x.x | F45P | U24045 | HP LaserJet 4250 | SA0PRINT03 | Q5403A | 0
PRN26-02 | x.x.x.x | RD1P |  | HP LaserJet 9000 MFP | DO26PRINT100 | Q2458A | 0
H06L | x.x.x.x | H06P | U41006 | HP LaserJet 9000 MFP | SA0PRINT04 | Q2458A | 2 | IM4057386 | 28 | IM4057386 | 28 | IM4057386 | 28 | IM4057386
A43L | x.x.x.x |  |  | HP LaserJet 9000 MFP | SA0PRINT01 | Q2458A | 0
PRN56-03 | x.x.x.x | TK3P | U45603 | HP LaserJet 9000 MFP | DO56PRINT100 | Q2458A | 5 | IM4062402 | 173 | IM4062771 | 174 | IM4062771 | 174 | IM4062771
PRN4-03 | x.x.x.x | LB9I | U78509 | HP LaserJet 9000 MFP | DO4MEM01 | Q2458A | 0
I05L | x.x.x.x | I05L | U6851 | HP LaserJet 4200 | SA0PRINT03/04 | Q2428A | 0
PRN06-18 | x.x.x.x | RV0S | U50600 | HP LaserJet 9000 MFP | DO6PRINT100 | Q2458A | 0
G10L | x.x.x.x | G10P | U31010 | HP LaserJet 4200 | SA0PRINT04 | Q2426A | 1 | IM4057439 | 27
PRN06-11 | x.x.x.x | [NAME] | U30601 | HP LaserJet 4200 | DO6PRINT100 | Q2428A | 0
PRN94-12 | x.x.x.x |  |  | HP LaserJet M4345 MFP | ST0PRINT101 | CB426A | 0
D23L | x.x.x.x | D23P | U40023 | HP LaserJet 9000 MFP | SA0PRINT02 | C8523A | 0
B09L | x.x.x.x | B09P | U20009 | HP LaserJet 4200 | SA0PRINT01 | Q2428A | 1 | IM4057377 | 8
B40L | x.x.x.x |  |  | HP LaserJet 9000 MFP | SA0PRINT01 | Q2458A | 0
PRN45-19 | x.x.x.x | BURA | U44501 | HP LaserJet 9000 MFP | DO45MEM100 | Q2458A | 2 | IM4056203 | 150 | IM4060049 | 151
PRN82-04 | x.x.x.x | VICI | U4822 | HP LaserJet 9000 MFP | DO82PRINT100 | Q2458A | 1 | IM4064483 | 204
PRN37-03 | x.x.x.x | AH2P | U43702 | HP LaserJet 9000 MFP | SA0PRINT109 | Q2458A | 0
[NAME] | x.x.x.x | D11P | U40011 | HP LaserJet 8150 | SA0PRINT02 | CXXXXA | 0
H00L | x.x.x.x | H00P | U41000 | HP LaserJet 4200 | SA0PRINT04 | Q2426A | 0
PRN61-02 | x.x.x.x | UP0S | U56100 | HP LaserJet 9000 MFP | [NAME] | Q2458A | 0
E32L | x.x.x.x | E32P | U11032 | HP LaserJet 9000 MFP | SA0PRINT03 | Q2458A | 1 | IM4056234 | 19
B10L | x.x.x.x | B10L | U20010 | HP LaserJet 4200 | SA0PRINT01 | Q2428A | 0
A44L | x.x.x.x |  |  | HP LaserJet 9000 MFP | SA0PRINT01 | CXXXXA | 0
B18L | x.x.x.x | B18P | U20018 | HP LaserJet 4200 | SA0PRINT01 | Q2426A | 0
PRN7-05 | x.x.x.x | VA4P | U40705 | HP LaserJet 9000 MFP | DO7PRINT100 | Q2458A | 0
G12L | x.x.x.x | G12P | U31012 | HP LaserJet 4200 | SA0PRINT04 | Q2428A | 0
PRN24-01 | x.x.x.x | AL1P | U42401 | HP LaserJet 9000 MFP | DO24PRINT100 | Q2458A | 0
B39L | x.x.x.x |  |  | HP LaserJet 9000 MFP | SA0PRINT01 | Q2458A | 0
PRN64-03 | x.x.x.x | CU3P |  | HP LaserJet 9000 MFP | [NAME] | Q2458A | 1 | IM4065211 | 185
G00L | x.x.x.x | G00P | [NAME] | HP LaserJet 4200 | SA0PRINT04 | Q2428A | 0
PRN05-02 | x.x.x.x | BF0P | U40500 | HP LaserJet 9000 MFP | DO5PRINT100 | Q2458A | 0
I01L | x.x.x.x | I01L | U14007 | HP LaserJet 9000 MFP | SA0PRINT04 | Q2458A | 0
D29L | x.x.x.x | D29P | U40029 | HP LaserJet 9000 MFP | SA0PRINT02 | Q2458A | 0
C37L | x.x.x.x | C37P | [NAME] | HP LaserJet 4200 | SA0PRINT02 | Q2428A | 0
PRN45-03 | x.x.x.x | BURR | U44518 | HP LaserJet 9000 MFP | DO45MEM100 | Q2458A | 0
G22L | x.x.x.x | G22P | U31022 | HP LaserJet 9000 MFP | SA0PRINT04 | Q2458A | 0
PRN54-03 | x.x.x.x | CO3C | U15403 | HP LaserJet 9000 MFP | DO54PRINT100 | Q2458A | 0
PRN05-05 | x.x.x.x | BF2C | U30502 | HP LaserJet 4050 | DO5PRINT100 | CXXXXA | 0
PRN25208-05 | x.x.x.x | HN4P | U70804 | HP LaserJet 9000 MFP | DO25PRINT100 | Q2458A | 0
PRN45-11 | x.x.x.x | BURF | U44506 | HP LaserJet 9000 MFP | DO45MEM100 | Q2458A | 0
F52L | x.x.x.x | F52P | U24052 | HP LaserJet 4250 | SA0PRINT03 | Q5403A | 0
A22L | x.x.x.x | A22P | U10022 | HP LaserJet 4200 | SA0PRINT01 | Q2426A | 0
PRN55-01 | x.x.x.x | GN0P | U45001 | HP LaserJet 9000 MFP | DO55PRINT100 | Q2458A | 0
H07L | x.x.x.x | H07L | U41007 | HP LaserJet 9000 MFP | SA0PRINT05 | Q2458A | 0
PRN78-14 | x.x.x.x | CMDP | U47813 | HP LaserJet 4050 | DO78PRINT100 | CXXXXA | 0
PRN49-16 | x.x.x.x | ES8C | U34908 | HP LaserJet 4050 | DO49PRINT100 | CXXXXA | 0
PRN47-04 | x.x.x.x | [NAME] | U44703 | HP LaserJet 9000 MFP | DO47PRINT100 | Q2458A | 0
B00L | x.x.x.x | [NAME] |  | HP LaserJet 8150 | SA0PRINT01 | CXXXXA | 0
G02L | x.x.x.x | G02P | U31002 | HP LaserJet 8150 | SA0PRINT04 | CXXXXA | 0
PRN06-10 | x.x.x.x | RV0C | U30600 | HP LaserJet 9000 MFP | DO6PRINT100 | Q2458A | 0
E05L | x.x.x.x | E05P | U11005 | HP LaserJet 4200 | SA0PRINT03 | Q2428A | 0