Spreadsheet: 156270d1337247680-excel-2007-transposing-values-w-duplicate-fields-vertically-arranged-horizontally-expected-result
Sheet: Sheet1

F | A | G | M | W | Y | T | DFP SETGROUP | U204VSYSVAR01 | U204VDEFAULT03 | DFP SPWD1 | DFP MPWD1 | DFP #EMVALLOWED | DFP PABX1 | DFP EMVPIN1 | DFP HSBCTID1 | DFP HSBCMID1 | DFP HSBCGAP1 | DFP HSBCAST1 | DFP HSBITID1 | DFP HSBIMID1 | DFP HSBIGAP1 | DFP HSBIAST1 | DFP HSBITID2 | DFP HSBIMID2 | DFP HSBIGAP2 | DFP HSBIAST2 | DFP HSBITID3 | DFP HSBIMID3 | DFP HSBIGAP3 | DFP HSBIAST3 | DFP HSBITID4 | DFP HSBIMID4 | DFP HSBIGAP4 | DFP HSBIAST4 | DFP HSBITID5 | DFP HSBIMID5 | DFP HSBIGAP5 | DFP HSBIAST5 | DFP HMCRTID1 | DFP HMCRMID1 | DFP HMCRGAP1 | DFP HMCRAST1 | DFP HLOYTID1 | DFP HLOYMID1 | DFP HLOYGAP1 | DFP HLOYAST1 | DFP AMEXTID1 | DFP AMEXMID1 | DFP AMEXGAP1 | DFP AMEXAST1 | DFP DINCTID1 | DFP DINCMID1 | DFP DINCGAP1 | DFP DINCAST1 | DFP JCBITID1 | DFP JCBIMID1 | DFP JCBIGAP1 | DFP JCBIAST1 | DFP PYCTID1 | DFP PYCMID1 | DFP PYCGAP1 | DFP PYCAST1 | DFP MCPTID1 | DFP [NAME] | DFP TENVAL1 | DFP TENVAL2 | DFP TENVAL3 | DFP TENVAL4 | DFP TENVAL5 | DFP TENTXT1 | DFP TENTXT2 | DFP TENTXT3 | DFP TENTXT4 | DFP TENTXT5 | DFP INTMIN1 | DFP INTMIN2 | DFP INTMIN3 | DFP INTMIN4 | DFP INTMIN5 | DFP INTMAX1 | DFP INTMAX2 | DFP INTMAX3 | DFP INTMAX4 | DFP INTMAX5 | DFP R1HDR1 | DFP R1HDR2 | DFP R1HDR3 | DFP R1HDR4 | DFP R1HDR5 | DFP R6HDR1 | DFP R4FDR1 | DFP R3HDR1 | DFP R4HDR1 | DFP R5HDR1 | DFP R1FDR1 | DFP R2FDR1 | DFP PRIAP1 | DFP SECAP1 | DFP PRISP1 | DFP SECSP1 | DFP PRIAP2 | DFP SECAP2 | DFP PRISP2 | DFP SECSP2 | DFP PRIAP3 | DFP SECAP3 | DFP PRISP3 | DFP SECSP3 | DFP PRIAP4 | DFP SECAP4 | DFP PRISP4 | DFP SECSP4 | DFP PRIAP5 | DFP SECAP5 | DFP PRISP5 | DFP SECSP5 | DFP PRIAP6 | DFP SECAP6 | DFP PRISP6 | DFP SECSP6 | DFP PRIAP7 | DFP SECAP7 | DFP PRISP7 | DFP SECSP7 | DFP PRIAP8 | DFP SECAP8 | DFP PRISP8 | DFP SECSP8 | DFP PRIAP9 | DFP SECAP9 | DFP PRISP9 | DFP SECSP9 | DFP PRIIP1 | DFP PRIIP2 | DFP PRIIP3 | DFP PRIIP4 | DFP PRIIP5 | DFP PRIIP6 | DFP PRIIP7 | DFP PRIIP8 | DFP PRIIP9 | DFP TXNPRT1 | DFP TXNPRT2 | DFP TXNPRT3 | DFP TXNPRT4 | DFP TXNPRT5 | DFP TXNPRT6 | DFP TXNPRT7 | DFP TXNPRT8 | DFP TXNPRT9 | DFP TIDMSK1 | DFP TIDMSK2 | DFP TIDMSK3 | DFP TIDMSK4 | DFP TIDMSK5 | DFP TIDMSK6 | DFP TIDMSK7 | DFP TIDMSK8 | DFP TIDMSK9 | DFP MIDMSK1 | DFP MIDMSK2 | DFP MIDMSK3 | DFP MIDMSK4 | DFP MIDMSK5 | DFP MIDMSK6 | DFP MIDMSK7 | DFP MIDMSK8 | DFP MIDMSK9 | DFP CRDFEE1 | DFP CRDFEE2 | DFP CRDFEE3 | DFP CRDFEE4 | DFP CRDFEE5 | DFP CRDFEE6 | DFP GPMTID1 | DFP GPMTID2 | DFP GPMTID3 | DFP GPMTID4 | DFP GPMTID5 | DFP GPMTID6 | DFP GPMCUR1 | DFP GPMCUR2 | DFP GPMCUR3 | DFP GPMCUR4 | DFP GPMCUR5 | DFP GPMCUR6 | DFP FLRLMT1 | DFP FLRLMT2 | DFP FLRLMT3 | DFP FLRLMT4 | DFP FLRLMT5 | DFP FLRLMT6 | DFP FLRLMT7 | DFP FLRLMT8 | DFP FLRLMT9 | DFP FLRLMT10 | DFP FLRLMT11 | DFP FLRLMT12 | DFP FLRLMT13 | DFP FLRLMT15 | DFP FLRLMT16 | DFP FLRLMT17 | DFP FLRLMT18 | DFP FLRLMT19 | DFP FLRLMT20 | DFP FLRLMT21 | DFP FLRLMT22 | DFP FLRLMT23 | DFP FLRLMT24 | DFP FLRLMT25 | DFP FLRLMT26 | DFP FLRLMT27 | DFP FLRLMT28 | DFP FLRLMT29 | DFP FLRLMT30 | DFP FLRLMT31 | DFP FLRLMT32 | DFP MANENT1 | DFP MANENT2 | DFP MANENT3 | DFP MANENT4 | DFP MANENT5 | DFP MANENT6 | DFP MANENT7 | DFP MANENT8 | DFP MANENT9 | DFP MANENT10 | DFP MANENT11 | DFP MANENT12 | DFP MANENT13 | DFP MANENT14 | DFP MANENT15 | DFP MANENT16 | DFP MANENT17 | DFP MANENT18 | DFP MANENT19 | DFP MANENT20 | DFP MANENT21 | DFP MANENT22 | DFP MANENT23 | DFP MANENT24 | DFP MANENT25 | DFP MANENT26 | DFP MANENT27 | DFP MANENT28 | DFP MANENT29 | DFP MANENT30 | DFP MANENT31 | DFP MANENT32 | DFP OFFL1 | DFP OFFL2 | DFP OFFL3 | DFP OFFL4 | DFP OFFL5 | DFP OFFL6 | DFP OFFL7 | DFP OFFL8 | DFP OFFL9 | DFP OFFL10 | DFP OFFL11 | DFP OFFL12 | DFP OFFL13 | DFP OFFL14 | DFP OFFL15 | DFP OFFL16 | DFP OFFL17 | DFP OFFL18 | DFP OFFL19 | DFP OFFL20 | DFP OFFL21 | DFP OFFL22 | DFP OFFL23 | DFP OFFL24 | DFP OFFL25 | DFP OFFL26 | DFP OFFL27 | DFP OFFL28 | DFP OFFL29 | DFP OFFL30 | DFP OFFL31 | DFP OFFL32 | DFP REFN1 | DFP REFN2 | [NAME] | DFP REFN4 | DFP REFN5 | DFP REFN6 | DFP REFN7 | DFP REFN8 | DFP REFN9 | DFP REFN10 | DFP REFN11 | DFP REFN12 | DFP REFN13 | DFP REFN14 | DFP REFN15 | DFP REFN16 | DFP REFN17 | DFP REFN18 | DFP REFN19 | DFP REFN20 | DFP REFN21 | DFP REFN22 | DFP REFN23 | DFP REFN24 | DFP REFN25 | DFP REFN26 | DFP REFN27 | DFP REFN28 | DFP REFN29 | DFP REFN30 | DFP REFN31 | DFP REFN32 | DFP AUTH1 | DFP AUTH2 | DFP AUTH3 | DFP AUTH4 | DFP AUTH5 | DFP AUTH6 | DFP AUTH7 | DFP AUTH8 | DFP AUTH9 | DFP AUTH10 | DFP AUTH11 | DFP AUTH12 | DFP AUTH13 | DFP AUTH14 | DFP AUTH15 | DFP AUTH16 | DFP AUTH17 | DFP AUTH18 | DFP AUTH19 | DFP AUTH20 | DFP AUTH21 | DFP AUTH22 | DFP AUTH23 | DFP AUTH24 | DFP AUTH25 | DFP AUTH26 | DFP AUTH27 | DFP AUTH28 | DFP AUTH29 | DFP AUTH30 | DFP AUTH31 | DFP AUTH32 | DFP AUSRTY1 | DFP STTPRN | DFP QPSPRN | DFP PYCF1 | DFP EXTIPP1 | E
Omni-V510G | G5GVS204 | HOUSEHOLDS | 03-01-12 01:44p | admin | 03-01-12 01:53:08p | 61000385 | 2 | 0 | 0 | 0000 | 0000 | 1 | 0 | 1 | 61000385 | 073000424001103 | 0 | 0 | 61000385 | 073000424002103 | 0 | 0 | 61000385 | 073000424003103 | 0 | 0 | 61000385 | 073000424004103 | 0 | 0 | 61000385 | 073000424005103 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 6 | 9 | 12 | 0 | 3 MONTHS | 6 MONTHS | 9 MONTHS | 12 MONTHS | 0 | 0 | 0 | 0 | 0 | 0 | 99999999 | 99999999 | 99999999 | 99999999 | 99999999 | HITCHPRO CO | HITCHPRO CO | HITCHPRO CO | HITCHPRO CO | HITCHPRO CO | 0 | 0 | 3675 BAUTISTA ST | BRGY PALANAN | MAKATI CITY | 0 | 0 | 8865758 | 9768040 | 8865758 | 9768040 | 8865758 | 9768040 | 8865758 | 9768040 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 29691098 | 29691098 | 29691098 | 29691098 | 29691098 | 29691098 | 29691098 | 29691098 | SSL.AP.GLOBALPAY.COM | SSL.AP.GLOBALPAY.COM | SSL.AP.GLOBALPAY.COM | SSL.AP.GLOBALPAY.COM | 64.27.240.42 | 64.27.240.42 | SSL.AP.GLOBALPAY.COM | SSL.AP.GLOBALPAY.COM | SSL.AP.GLOBALPAY.COM | 443 | 443 | 443 | 443 | 443 | 443 | 443 | 443 | 443 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 100 | 61000385
Omni-V510G | G5GVS204 | HOUSEHOLDS | 03-02-12 10:44a | admin | 03-02-12 10:50:03a | 61000351 | 2 | 0 | 0 | 0000 | 0000 | 1 | 0 | 1 | 61000351 | 073000031003108 | 0 | 0 | 61000351 | 073000031011105 | 0 | 0 | 61000351 | 073000031012105 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 6 | 0 | 0 | 0 | 3 MONTHS | 6 MONTHS | 9 MONTHS | 12 MONTHS | 24 MONTHS | 0 | 0 | 0 | 0 | 0 | 99999999 | 99999999 | 99999999 | 99999999 | 99999999 | LCC DEPT STORE-MASBATE | LCC DEPT STORE-MASBATE | LCC DEPT STORE-MASBATE | LCC DEPT STORE-MASBATE | LCC DEPT STORE-MASBATE | 0 | 0 | PORT AREA [NAME] STREET | BRGY PATING | MASBATE CITY | 0 | 0 | 8865758 | 9768040 | 8865758 | 9768040 | 8865758 | 9768040 | 8865758 | 9768040 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 29691098 | 29691098 | 29691098 | 29691098 | 29691098 | 29691098 | 29691098 | 29691098 | SSL.AP.GLOBALPAY.COM | SSL.AP.GLOBALPAY.COM | SSL.AP.GLOBALPAY.COM | SSL.AP.GLOBALPAY.COM | 64.27.240.42 | 64.27.240.42 | SSL.AP.GLOBALPAY.COM | SSL.AP.GLOBALPAY.COM | SSL.AP.GLOBALPAY.COM | 443 | 443 | 443 | 443 | 443 | 443 | 443 | 443 | 443 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 100 | 61000351
Omni-V510G | G5GVS204 | HOTELS | 10-12-11 04:15p | admin | 204-HO-MC | 2 | 0 | 0 | 0000 | 0000 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 29691098 | 29691098 | 29691098 | 29691098 | 29691098 | 29691098 | 29691098 | 29691098 | SSL.AP.GLOBALPAY.COM | SSL.AP.GLOBALPAY.COM | SSL.AP.GLOBALPAY.COM | SSL.AP.GLOBALPAY.COM | 64.27.240.42 | 64.27.240.42 | SSL.AP.GLOBALPAY.COM | SSL.AP.GLOBALPAY.COM | SSL.AP.GLOBALPAY.COM | 443 | 443 | 443 | 443 | 443 | 443 | 443 | 443 | 443 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 100 | 204-HO-MC | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A