Spreadsheet: 169286d1342770821-populating-a-list-from-a-data-table-0a7
Sheet: DataTable

 | Date | Report No | Client Name | Devision | Subdivision | Product Group | Merchandiser | Department | Supplier | Description | Sample Qty | Test ID | Test Name (Name Line 1) | Name Line 2 | Norm/Standard/Protocol | QTY | Price | Currency
 | 20120607 | S1201529 | Client 1 | A | ABP | UU5 | [NAME] | 1 | Supplier 2 | M12007 GL Guardians | 10pcs | 01-079-1-13 | Test A | Protocol 1 | EN | 8 | 4800 | USD
 | 20120605 | S1201506 | Client 1 | A | ABP | UU5 | [NAME] | 1 | Supplier 3 | M12008/M12009 Aqualad/Kid Flash(Intervention No.1) | 10pcs | 01-004-2-13 | Test B | Protocol 2 | ISO | 10 | 4000 | USD
 | 20120614 | S1201611 | Client 1 | B | ZPA-ZHA | [NAME] | [NAME] | 1 | Supplier 4 | #76642839 Tin snowman/santa 2 asst | 4pcs | 01-008-1-13 | Test C | Protocol 6 | PRO | 13 | 3003 | USD
 | 20120628 | S1201752 | Client 2 | C | MHA | MZS | [NAME] | 1 | Supplier 2 | #76642839 Tin snowman/santa 3 asst | 1ctn | 01-002-1-03 | Test A | Protocol 5 | EN | 14 | 2842 | USD
 | 20120614 | S1201610 | Client 1 | B | ZPA-ZHA | [NAME] | [NAME] | 1 | Supplier 3 | #[NAME] family | 2pcs | 01-008-1-13 | Test B | Protocol 1 | EN | 10 | 2310 | USD
 | 20120605 | S1201503 | Client 1 | A | CTS | P5 | [NAME] | 2 | not provided | #96000 Kurio Tablet 7'' | 1pc | 04-349-3-01 | Test D | Protocol 1 | ISO | 1 | 2200 | USD
 | 20120614 | S1201613 | Client 1 | B | ZPA-ZHA | [NAME] | [NAME] | 1 | Supplier 1 | #76685040 Needlefelted santa | 4pcs | 01-008-1-13 | Test F | Protocol 2 | PRO | 9 | 2079 | USD
 | 20120614 | S1201612 | Client 1 | B | ZPA-ZHA | [NAME] | [NAME] | 1 | Supplier 4 | #76685039 Needlefelted Christmas Tree | 4pcs | 01-008-1-13 | Test Y | Protocol 6 | EN | 8 | 1848 | USD
 | 20120529 | S1201425 | Client 2 | C | PBZ | PBS | [NAME] | 1 | [NAME] | LE0103 Smart Long Lock Tote | 1pc | 01-055-1-12 | Test YU | Protocol 5 | ISO | 3 | 1617 | USD
 | 20120619 | S1201647 | Client 1 | B | ZPA-ZHH | ZHX | [NAME] | 2 | Supplier 1 | HD-13412 tea-light | 1ctn | 05-001-2-02 | Test A | Protocol 1 | PRO | 8 | 1400 | USD
 | 20120614 | S1201607 | Client 1 | B | ZPA-ZHA | [NAME] | [NAME] | 1 | Supplier 2 | #76642837 Santa head | 2pcs | 01-008-1-13 | Test B | Protocol 1 | EN | 6 | 1386 | USD
 | 20120625 | S1201683 | Client 2 | C | MHA | MZS | [NAME] | 4 | Supplier 3 | #68100/01/53 2pcs of MDF board 50*50cm | 2pcs | 01-011-1-06 | Test C | Protocol 2 | ISO | 1 | 1330 | USD
 | 20120531 | S1201459 | Client 1 | A | ABP | UU5 | [NAME] | 1 | Supplier 1 | [NAME] (Intervention 2) | 5pcs | 01-004-2-13 | Test A | Protocol 6 | EN | 3 | 1200 | USD
 | 20120606 | S1201524 | Client 2 | C | PBZ | PBS | lily [NAME] | 1 | Supplier 2 | [NAME] Two Tote | 1pc | 01-055-1-12 | Test B | Protocol 5 | ISO | 2 | 1078 | USD
 | 20120612 | S1201585 | Client 2 | C | PBZ | PBS | lily [NAME] | 1 | Supplier 4 | Monsoon SB 1089V2 [NAME] | 1pc | 01-055-1-12 | Test D | Protocol 1 | PRO | 2 | 1078 | USD
 | 20120614 | S1201609 | Client 1 | B | ZPA-ZHA | [NAME] | [NAME] | 1 | Supplier 1 | #76642836 Reindeer head | 2pcs | 01-008-1-13 | Test F | Protocol 2 | ISO | 4 | 924 | USD
 | 20120606 | S1201526 | Client 1 | B | [NAME] | ZUM | [NAME] | 2 | Supplier 4 | Set/4 coaster in plastic | 4pcs | 04-327-3-08 | Test Y | Protocol 6 | PRO | 1 | 850 | USD
 | 20120606 | S1201527 | Client 1 | B | [NAME] | ZUM | [NAME] | 2 | Supplier 7 | Storage in MDF | 1pc | 04-327-3-08 | Test YU | Protocol 5 | ISO | 1 | 850 | USD
 | 20120614 | S1201599 | Client 2 | C | MHA | MZS | [NAME] | 1 | Supplier 1 | Spicery items | 1ctn | 01-047-1-07 | Test A | Protocol 1 | PRO | 2 | 840 | USD
 | 20120606 | S1201525 | Client 1 | B | ZPA-ZHA | ZAS | [NAME] | 2 | Supplier 2 | #798113 CAKE STAND (GLASS) | 1ctn | 04-059-3-08 | Test B | Protocol 1 | EN | 1 | 800 | USD
 | 20120625 | S1201685 | Client 2 | C | MHA | MZS | [NAME] | 1 | Supplier 1 | #68100/01/53 2 pc of MDF board in A4 size,2 pcs of solid wood 10*4cm | 2pcs | 01-045-1-06 | Test C | Protocol 2 | ISO | 2 | 770 | USD
 | 20120606 | S1201511 | Client 2 | C | PBZ | PBU | [NAME] | 3 | Supplier 3 | #834945 Leopard set of 3 | 2pcs | 04-223-1-12 | Test A | Protocol 6 | PRO | 3 | 750 | USD
 | 20120605 | S1201499 | Client 2 | C | PBZ | PBS | lily [NAME] | 1 | Supplier 4 | #7377/7378/7379Man Gift Coanvan Owl Wallet/coin purse | 1pc | 01-055-1-12 | Test B | Protocol 5 | EN | 1 | 700.7 | USD
 | 20120618 | S1201639 | Client 2 | C | PBZ | PBS | lily [NAME] | 1 | Supplier 3 | #7377/7378/7379 Man Gift Coated Canvas Owl Wallet/coin purse | 1pc | 01-055-1-12 | Test D | Protocol 1 | ISO | 1 | 700.7 | USD
 | 20120607 | S1201536 | Client 1 | B | [NAME] | ZUM | [NAME] | 1 | Supplier 1 | T200091199 CS MELABOO SERVING PLATTER-TURQ BRNT | 15pcs | 01-023-2-05 | Test F | Protocol 2 | PRO | 1 | 700 | USD
 | 20120620 | S1201671 | Client 1 | B | ZPA-ZHH | ZHX | [NAME] | 1 | Supplier 4 | Stvle #[NAME] Black / Blue geisha Sushi Set | 1ctn | 01-031-2-05 | Test Y | Protocol 1 | EN | 1 | 700 | USD
 | 20120614 | S1201608 | Client 1 | B | ZPA-ZHA | [NAME] | [NAME] | 1 | Supplier 4 | #76642840 Metal bell owl | 2pcs | 01-008-1-13 | Test YU | Protocol 2 | EN | 3 | 693 | USD
 | 20120607 | S1201536 | Client 1 | B | [NAME] | ZUM | [NAME] | 2 | Supplier 1 | T200091199 CS MELABOO SERVING PLATTER-TURQ BRNT | 15pcs | 04-327-3-05 | Test A | Protocol 6 | ISO | 1 | 680 | USD
 | 20120605 | S1201508 | Client 1 | B | [NAME] | ZUM | [NAME] | 2 | Supplier 3 | Candle holder in resin | 1pc | 04-327-3-02 | Test B | Protocol 5 | EN | 1 | 600 | USD
 | 20120605 | S1201509 | Client 1 | B | [NAME] | ZUM | [NAME] | 2 | Supplier 2 | Metal candle holder | 1pc | 04-327-3-02 | Test D | Protocol 2 | ISO | 1 | 600 | USD
 | 20120607 | S1201537 | Client 1 | B | [NAME] | ZUM | [NAME] | 2 | Supplier 2 | T065160257 PN MUSHROOM FIGURAL CANDLE SM | 6pcs | 04-327-3-02 | Test A | Protocol 6 | EN | 1 | 600 | USD
 | 20120607 | S1201538 | Client 1 | B | [NAME] | ZUM | [NAME] | 2 | Supplier 1 | T065160258 PN OWL FIGURAL CANDLE LG | 6pcs | 04-327-3-02 | Test B | Protocol 5 | ISO | 1 | 600 | USD
 | 20120607 | S1201539 | Client 1 | B | [NAME] | ZUM | [NAME] | 2 | Supplier 2 | T065160269 PN 9PK TAPER CANDLES | 6pcs | 04-327-3-02 | Test D | Protocol 1 | PRO | 1 | 600 | USD