Spreadsheet: 62679d1263574712-merging-a-file-to-defined-file-format-example
Sheet: outfile

File name | Door | Shelf | Shelf Position | Name | UPC | SLIN | Item Count
test | 1 | 1 | 1 | Grap@ Squar@d | 8500000533 | 22222 | 1
test | 1 | 1 | 2 | Gall^ ZpL 4/187B | 8500000533 | 22222 | 1
test | 1 | 1 | 3 | [NAME] @LL Gr*g*^ 1/750B | 8500000444 | 22222 | 1
test | 1 | 1 | 4 | S^n^#a Cr@st ZpL 1/750B | 9645600033 | 22222 | 1
test | 1 | 1 | 5 | Th^usand ^aks ZpL 1/750B | 8605457440 | 22222 | 1
test | 1 | 1 | 6 | Y^s*#*t@ R^ad ZpL | 8362000045 | 22222 | 1
test | 1 | 1 | 7 | B@r*ng@r Wh*t@ @^P 1/750B | 8986900752 | 22222 | 1
test | 1 | 2 | 1 | ## 1/24C | 8077095726 | 600616 | 1
test | 1 | 2 | 2 | ZZ 1/24C | 8982700642 | 600636 | 1
test | 1 | 2 | 3 | N@^n BB L*#@ 1/24C | 6820000277 | 600694 | 1
test | 1 | 2 | 4 | Ch@lada N@^n BB 1/24C | 6820000747 | 600241 | 1
test | 1 | 2 | 5 | Ch@lada N@^nw@*s@r 1/24C | 6820000745 | 600261 | 1
test | 1 | 2 | 6 | A@@ Wat@r#@l^n 1/24C | 89526700607 | 602226 | 1
test | 1 | 2 | 7 | A@@ Fru*t Punch 1/24C | 89526700604 | 606663 | 1
test | 1 | 2 | 8 | J^^s@ Jungl@ 1/24C | 83305000995 | 602620 | 1
test | 1 | 2 | 9 | J^^s@ Drag^n 1/24C | 83305000997 | 606919 | 1
test | 1 | 3 | 1 | PLP 1/24C | 7289000669 | 606293 | 1
test | 1 | 3 | 2 | F^st@rs Lag@r 1/25C | 7089706336 | 600753 | 1
test | 1 | 3 | 3 | K*ng C^bra 1/16C x6 | 6820000629S | A602664 | 1
test | 1 | 3 | 4 | Sparks 1/16C | 7825000459S | 606326 | 1
test | 1 | 3 | 5 | [NAME] 1/16C | 7825000490S | 602027 | 1
test | 1 | 3 | 6 | Sparks Plus 1/16C | 7825000476S | 606760 | 1
test | 1 | 3 | 7 | T*lt L@#^n L*#@ 8 1/16C | 6820000738S | 606907 | 1
test | 1 | 3 | 8 | #*k@s HARD@R L@#^nad@ 1/16C | 73598525875 | 606161 | 1
test | 1 | 3 | 9 | #*k@s HARD@R Cranb@rry L@#^nad@ 1/16C | 73598506037 | 606195 | 1
test | 1 | 4 | 1 | N@^n *c@ 1/24C | 6820000495 | 602161 | 1
test | 1 | 4 | 2 | QQQ BB 1/24C | 6820000225 | 600431 | 2
test | 1 | 4 | 3 | QQQ *c@ 1/24C | 6820000359 | 600331 | 1
test | 1 | 4 | 4 | [NAME] 1/24C | 6820000236 | 606649 | 2
test | 1 | 4 | 5 | RRRR 1/24C | 3460000005 | 600026 | 1
test | 1 | 4 | 6 | Q{PP 1/24C | 3460000880 | 600436 | 1
test | 1 | 5 | 1 | N@^nw@*s@r 1/40B | 6820000627 | 600579 | 1
test | 1 | 5 | 2 | N@^n BB 1/40B | 6820000670 | 606637 | 1
test | 1 | 5 | 3 | K*ng C^bra 1/32B | 6820000630 | 606302 | 3
test | 1 | 5 | 4 | #*ck@ys #alt 1/40B | 3460000685 | 600475 | 1
test | 1 | 5 | 5 | ld@ @ng 800 1/40B | 3460000722 | 600555 | 1
test | 1 | 6 | 1 | RRRR 1/32B | 3460000036 | 600463 | 2
test | 1 | 6 | 2 | N@^n *c@ 1/32B | 6820000245 | 606179 | 1
test | 1 | 6 | 3 | QQQ BB 1/32B | 6820000467 | 600063 | 1
test | 1 | 6 | 4 | QQQ *c@ 1/32B | 6820000647 | 606366 | 2
test | 1 | 6 | 5 | #agnu# #alt L*qu^r 1/32B | 3460000086 | 600796 | 1
test | 2 | 1 | 1 | ## 3/24C | 8077095774 |  | 1
test | 2 | 1 | 2 | ZZ 3/24C | 8982730246 | 602011 | 1
test | 2 | 1 | 3 | QQQ BB 3/24C | 6820009990 | 606967 | 1
test | 2 | 2 | 1 | N@^n BB 3/24C | 6820009985 | 0 | 3
test | 2 | 3 | 1 | N@^nw@*s@r 3/24C | 6820009984 | 606679 | 2
test | 2 | 3 | 2 | N@^n BB 3/24C | 6820009985 | 0 | 1
test | 2 | 4 | 1 | N@^nw@*s@r 1/24C | 6820000477 | 600022 | 4
test | 2 | 4 | 2 | Blu@ BB 1/24C | 7699030075 | 602515 | 2
test | 2 | 4 | 3 | Blu@ BB 3/24C | 7699030620 | 600167 | 1
test | 2 | 5 | 1 | N@^n BB 1/24C | 6820000478 | 600601 | 6
test | 2 | 5 | 2 | L*t@ 1/24C | 3460000355 | 600411 | 1
test | 2 | 5 | 3 | #*ll@r G@nu*n@ [NAME] 1/24C | 3460000555 | 602497 | 1
test | 2 | 5 | 4 | Blu@ 1/24C | 7699060076 | 602514 | 1
test | 2 | 6 | 1 | PL 1/24C | 9999900043 | 33333 | 4
test | 2 | 6 | 2 | St@@l R@s. H*gh Grav*ty 1/24C | 7825000328 | 602645 | 2
test | 2 | 6 | 3 | K*ng C^bra 1/24C | 6820000477 | 606621 | 1
test | 2 | 6 | 4 | Hurr*can@ H* Grav*ty 1/24C | 6820000536 | 606003 | 1
test | 2 | 6 | 5 | ld@ @ng 800 1/24C | 3460000762 | 602914 | 1
test | 2 | 7 | 1 | CCC @xtra 1/24B | 8077095746 | 606607 | 1
test | 2 | 7 | 2 | N@^n BB L*#@ 1/22B | 6820000264 | 606192 | 1
test | 2 | 7 | 3 | PLP 1/24B | 948700007 | 602245 | 1
test | 2 | 7 | 4 | St@lla Art^*s 1/22B | 78765000057 | 606795 | 1
test | 2 | 7 | 5 | N@^n [NAME] Wh@at 1/22B | 6820000349 | 606440 | 1
test | 2 | 7 | 6 | [NAME] Al@ 1/19B | 8834560055 | 600695 | 1
test | 2 | 7 | 7 | S#*rn^ff *c@ 1/24B | 8200072579 | 606035 | 1
test | 2 | 7 | 8 | S#*rn^ff *c@ Gr@@n Appl@ B*t@ 1/24B | 8200072902 | 602555 | 1
test | 3 | 1 | 1 | PLP 6/12B | 7289000066 | 600065 | 1
test | 3 | 1 | 2 | N@^n BB L*#@ 6/12L | 6820064996 | 606114 | 1
test | 3 | 1 | 3 | N@^n BB G^ld@n Wh@at 6/12L | 6820065998 | 606441 | 1
test | 3 | 1 | 4 | [NAME] Al@ 6/12B | 8834560005 | 606313 | 1
test | 3 | 1 | 5 | S#*rn^ff *c@ 6/11L | 8200072385 | 606412 | 1
test | 3 | 2 | 1 | CCC @xtra 6/12L | 8077095705 | 600371 | 1
test | 3 | 2 | 2 | ## 6/12B | 8077095775 | 606323 | 1
test | 3 | 2 | 3 | ZZ 18/12C | 8982790683 | 600313 | 1
test | 3 | 2 | 4 | N@^n BB G^ld@n Wh@at 12/12L | 6820065999 | 602274 | 1
test | 3 | 3 | 1 | PLP 12/12B | 7289000067 | 606566 | 1
test | 3 | 3 | 2 | ## 12/12B | 8077095757 | 600320 | 1
test | 3 | 3 | 3 | N@^n BB L*#@ 12/12L | 6820064990 | 606190 | 1
test | 3 | 4 | 1 | CCC @xtra 24/12L | 8077095708 | 600573 | 1
test | 3 | 4 | 2 | CCC @xtra 12/12L | 8077095765 | 606536 | 2
test | 3 | 5 | 1 | N@^nw@*s@r 18/12FRC | 6820066268 | 600029 | 2
test | 3 | 5 | 2 | N@^nw@*s@r 12/12L | 6820000776 | 600570 | 1
test | 3 | 5 | 3 | N@^nw@*s@r 18/12L | 6820066308 | 600269 | 1
test | 4 | 1 | 1 | N@^n BB 6/16C | 6820000665 | 600035 | 1
test | 4 | 1 | 2 | N@^n BB 6/12L | 6820000833 | 600040 | 2
test | 4 | 1 | 3 | N@^nw@*s@r 6/12L | 6820000834 | 600366 | 1
test | 4 | 1 | 4 | #*ch@l^b Ultra 6/12L | 6820005989 | 600034 | 1
test | 4 | 2 | 1 | N@^n BB 12/12C | 6820053047 | 600569 | 4
test | 4 | 2 | 2 | N@^nw@*s@r 12/12C | 6820066047 | 600507 | 1
test | 4 | 3 | 1 | N@^n BB 12/12L | 6820000779 | 600577 | 2
test | 4 | 3 | 2 | PL 12/12C | 9999900050 | 33333 | 2
test | 4 | 4 | 1 | N@^n BB 18/12FRC | 6820053268 | 600052 | 5
test | 4 | 5 | 1 | N@^n BB 24/12LBB | 6820053349 | 606622 | 1
test | 4 | 5 | 2 | N@^n BB 18/12FRC | 6820053268 | 600052 | 3
test | 5 | 1 | 1 | Blu@ BB 6/12L | 7699030005 | 606303 | 1
test | 5 | 1 | 2 | Blu@ BB 6/12C | 7699000008 | 600369 | 1
test | 5 | 1 | 3 | N@^n BB 6/12C | 6820000607 | 600666 | 1
test | 5 | 1 | 4 | N@^nw@*s@r 6/12C | 6820000067 | 600062 | 1
test | 5 | 1 | 5 | N@^nw@*s@r 6/16C | 6820000068 | 600067 | 1
test | 5 | 2 | 1 | Blu@ BB 12/12L | 7699030079 | 602691 | 1
test | 5 | 2 | 2 | QQQ *c@ 12/12C | 6820000974 | 600666 | 1
test | 5 | 2 | 3 | QQQ BB 12/12C | 6820065047 | 600037 | 1
test | 5 | 2 | 4 | K@yst^n@ BB 12/12C | 7699048004 | 600569 | 1
test | 5 | 3 | 1 | Blu@ BB 1/194#BR | 7699030600 | 606653 | 1
test | 5 | 3 | 2 | Blu@ BB 18/12L | 7699030078 | 606676 | 1
test | 5 | 3 | 3 | RRRR 12/12L | 3460006509 | 606960 | 1
test | 5 | 4 | 1 | Blu@ BB 18/12C | 7699030067 | 600504 | 3
test | 5 | 4 | 2 | Blu@ BB 12/12C | 7699000048 | 600361 | 1
test | 5 | 4 | 3 | QQQ BB 18/12FRC | 6820065268 | 600510 | 1
test | 5 | 5 | 1 | N@^n BB 30/12D | 6820053030 | 603646 | 1
test | 5 | 5 | 2 | N@^n BB 18/12L | 6820053308 | 600215 | 2