Spreadsheet: 868300d1715020456-best-choice-to-get-desired-output-for-bulk-data-booktest
Sheet: Output1

 | Gender | Male
 | EmpID | Group | Period | Quantity |  |  |  |  |  | Revenue
 |  |  |  | 1.Region | 2.Region | 3.Region | 4.Region | 5.Region | 6.Region | 1.Region | 2.Region | 3.Region | 4.Region | 5.Region | 6.Region
 | [NAME] | C | 1st_Quarter | 872 | 317 | 76 | 85 | 198 | 6 | 8477 | 3492 | 1002 | 1134 | 1033 | 186
 | [NAME] | C | 2nd_Quarter | 1015 | 257 | 432 | 360 | 74 | 0 | 12286 | 3545 | 5184 | 3275 | 1314 | 0
 | EmpID_140200246 | C | 1st_Quarter | 659 | 306 | 146 | 0 | 358 | 59 | 6298 | 4280 | 2402 | 0 | 2779 | 362
 | EmpID_140200246 | C | 2nd_Quarter | 1439 | 45 | 109 | 109 | 145 | 58 | 13543 | 1510 | 2791 | 1325 | 1826 | 892
 | EmpID_150200118 | C | 1st_Quarter | 452 | 406 | 268 | 197 | 22 | 114 | 5424 | 2523 | 2125 | 2801 | 1441 | 1412
 | EmpID_150400843 | B | 1st_Quarter | 502 | 188 | 229 | 246 | 216 | 59 | 6071 | 1769 | 2902 | 1595 | 2622 | 432
 | EmpID_150400843 | B | 2nd_Quarter | 1148 | 291 | 235 | 130 | 193 | 3 | 14029 | 3987 | 1789 | 1934 | 2299 | 645
 | EmpID_160201309 | C | 1st_Quarter | 706 | 91 | 0 | 189 | 310 | 68 | 7833 | 1659 | 0 | 2713 | 3071 | 368
 | EmpID_160201309 | C | 2nd_Quarter | 1050 | 363 | 203 | 419 | 126 | 74 | 14905 | 2863 | 1368 | 2499 | 1740 | 354
 | EmpID_160202102 | A | 1st_Quarter | 827 | 212 | 265 | 121 | 137 | 36 | 8143 | 1484 | 3067 | 2277 | 2269 | 274
 | EmpID_160202102 | A | 2nd_Quarter | 1328 | 497 | 139 | 294 | 23 | 0 | 12627 | 5300 | 1256 | 3224 | 1136 | 0
 | [NAME] | D | 1st_Quarter | 709 | 236 | 79 | 215 | 290 | 80 | 7487 | 2237 | 1110 | 1446 | 2635 | 929
 | [NAME] | D | 2nd_Quarter | 1595 | 278 | 384 | 282 | 91 | 80 | 15450 | 3125 | 3658 | 3310 | 778 | 796
 | EmpID_160403102 | A | 1st_Quarter | 513 | 215 | 237 | 311 | 247 | 46 | 6757 | 2821 | 3181 | 1937 | 2174 | 615
 | EmpID_160403102 | A | 2nd_Quarter | 1619 | 367 | 213 | 231 | 139 | 0 | 15050 | 4463 | 3239 | 1931 | 1642 | 0
 | EmpID_160403178 | A | 1st_Quarter | 738 | 253 | 110 | 50 | 258 | 116 | 8849 | 1025 | 1761 | 2207 | 1851 | 957
 | EmpID_160403178 | A | 2nd_Quarter | 1049 | 462 | 45 | 286 | 51 | 0 | 16685 | 4436 | 1584 | 2830 | 929 | 0
 | EmpID_170200455 | A | 1st_Quarter | 710 | 69 | 353 | 14 | 189 | 86 | 7946 | 685 | 3115 | 753 | 2256 | 1390
 | EmpID_170200455 | A | 2nd_Quarter | 1087 | 486 | 340 | 424 | 54 | 0 | 14140 | 4914 | 3694 | 4853 | 706 | 0
 | EmpID_170200933 | C | 1st_Quarter | 1061 | 192 | 103 | 305 | 336 | 78 | 7870 | 1574 | 855 | 1392 | 2531 | 105
 | EmpID_170200933 | C | 2nd_Quarter | 1447 | 481 | 223 | 439 | 259 | 0 | 14076 | 5521 | 2847 | 5168 | 1927 | 0
 | EmpID_170201251 | A | 1st_Quarter | 707 | 287 | 174 | 248 | 190 | 100 | 5515 | 2870 | 1929 | 3181 | 1130 | 731
 | EmpID_170201251 | A | 2nd_Quarter | 1183 | 320 | 262 | 442 | 92 | 93 | 14375 | 4263 | 3168 | 4656 | 125 | 886
 | EmpID_170202223 | B | 1st_Quarter | 690 | 163 | 124 | 131 | 142 | 0 | 8485 | 2189 | 2118 | 1457 | 1975 | 0
 | EmpID_170202539 | D | 1st_Quarter | 707 | 217 | 266 | 58 | 225 | 178 | 7981 | 1420 | 1851 | 996 | 2181 | 1614
 | EmpID_170202539 | D | 2nd_Quarter | 1390 | 331 | 385 | 224 | 87 | 0 | 11580 | 2750 | 3047 | 1806 | 1083 | 0
 | EmpID_170203014 | A | 1st_Quarter | 489 | 354 | 70 | 209 | 346 | 117 | 5957 | 3723 | 988 | 1996 | 2327 | 763
 | EmpID_170203014 | A | 2nd_Quarter | 1269 | 343 | 609 | 232 | 304 | 0 | 12616 | 2393 | 4774 | 2016 | 2863 | 0
 | EmpID_170203133 | A | 1st_Quarter | 480 | 237 | 287 | 106 | 260 | 106 | 7278 | 3130 | 3441 | 1023 | 3008 | 828
 | EmpID_170203133 | A | 2nd_Quarter | 880 | 343 | 435 | 118 | 63 | 94 | 8457 | 3910 | 3811 | 2137 | 320 | 211
 | EmpID_170400361 | B | 1st_Quarter | 849 | 152 | 215 | 329 | 54 | 12 | 7471 | 2753 | 2322 | 2661 | 496 | 852
 | EmpID_170400361 | B | 2nd_Quarter | 1782 | 259 | 52 | 240 | 68 | 0 | 17077 | 5751 | 422 | 2544 | 1787 | 0
 | EmpID_170400655 | C | 1st_Quarter | 688 | 88 | 116 | 256 | 71 | 85 | 9427 | 974 | 1235 | 4027 | 387 | 686
 | EmpID_170400655 | C | 2nd_Quarter | 1062 | 259 | 472 | 313 | 77 | 135 | 10414 | 3209 | 3270 | 2619 | 748 | 1053
 | EmpID_170400665 | A | 1st_Quarter | 938 | 384 | 182 | 6 | 128 | 64 | 7921 | 4370 | 1856 | 672 | 1674 | 408
 | EmpID_170400665 | A | 2nd_Quarter | 1448 | 235 | 193 | 372 | 89 | 0 | 15458 | 1914 | 2106 | 6317 | 377 | 0
 | EmpID_170401523 | D | 1st_Quarter | 497 | 186 | 162 | 125 | 75 | 58 | 8876 | 2282 | 2058 | 2004 | 1325 | 1036
 | [NAME] | C | 1st_Quarter | 826 | 313 | 206 | 178 | 86 | 97 | 6179 | 3229 | 1510 | 1830 | 859 | 835
 | [NAME] | C | 2nd_Quarter | 1206 | 426 | 463 | 350 | 404 | 80 | 10653 | 5872 | 4701 | 2968 | 4768 | 425
 | EmpID_170402500 | D | 1st_Quarter | 864 | 298 | 140 | 25 | 125 | 8 | 9425 | 3285 | 1672 | 115 | 1232 | 488
 | EmpID_170402500 | D | 2nd_Quarter | 1491 | 460 | 147 | 337 | 30 | 0 | 13941 | 4184 | 1836 | 3503 | 984 | 0
 | EmpID_170402614 | C | 1st_Quarter | 780 | 368 | 240 | 84 | 120 | 100 | 4775 | 2989 | 1778 | 2574 | 874 | 266
 | EmpID_170402973 | B | 1st_Quarter | 587 | 208 | 106 | 87 | 364 | 93 | 7376 | 2714 | 1002 | 978 | 3581 | 682
 | EmpID_170403267 | A | 1st_Quarter | 608 | 341 | 61 | 258 | 120 | 111 | 7101 | 2811 | 899 | 2579 | 3608 | 2073
 | EmpID_170403267 | A | 2nd_Quarter | 1726 | 596 | 164 | 138 | 245 | 93 | 13776 | 5503 | 2577 | 1619 | 2334 | 604
 | [NAME] | A | 1st_Quarter | 511 | 132 | 155 | 216 | 191 | 154 | 5467 | 1952 | 4066 | 1396 | 3246 | 1382
 | [NAME] | A | 2nd_Quarter | 1132 | 562 | 358 | 174 | 94 | 154 | 12500 | 5572 | 4088 | 2219 | 852 | 1770
 | EmpID_170405322 | C | 1st_Quarter | 685 | 37 | 277 | 139 | 199 | 125 | 7748 | 366 | 3145 | 1420 | 1454 | 1343
 | EmpID_170405322 | C | 2nd_Quarter | 1440 | 219 | 241 | 237 | 213 | 23 | 15086 | 2764 | 3474 | 2482 | 1606 | 682
 | EmpID_170405573 | B | 1st_Quarter | 766 | 301 | 0 | 88 | 332 | 117 | 9363 | 3707 | 0 | 858 | 2667 | 1245
 | EmpID_170405573 | B | 2nd_Quarter | 801 | 234 | 273 | 290 | 109 | 127 | 14137 | 2671 | 2158 | 2433 | 1024 | 319
 | EmpID_170406074 | A | 1st_Quarter | 837 | 449 | 223 | 175 | 89 | 12 | 7376 | 4124 | 2723 | 1177 | 1458 | 149
 | EmpID_170406074 | A | 2nd_Quarter | 1540 | 568 | 121 | 178 | 118 | 103 | 17311 | 3408 | 1969 | 2383 | 1747 | 775
 | EmpID_170406500 | C | 1st_Quarter | 839 | 164 | 120 | 71 | 243 | 124 | 6834 | 2702 | 1293 | 1513 | 2335 | 1473
 | EmpID_170406500 | C | 2nd_Quarter | 1282 | 723 | 104 | 420 | 110 | 137 | 12198 | 4978 | 1103 | 4645 | 1175 | 1883
 | EmpID_180200517 | B | 1st_Quarter | 1011 | 81 | 132 | 102 | 279 | 43 | 10265 | 708 | 1299 | 830 | 1992 | 497
 | EmpID_180200517 | B | 2nd_Quarter | 1290 | 433 | 132 | 241 | 41 | 137 | 12955 | 4871 | 639 | 3998 | 398 | 1892
 | EmpID_180200688 | C | 1st_Quarter | 724 | 287 | 218 | 91 | 152 | 80 | 7429 | 2546 | 1416 | 1289 | 1950 | 962
 | EmpID_180200940 | A | 1st_Quarter | 482 | 310 | 119 | 232 | 329 | 110 | 6800 | 3509 | 1418 | 2299 | 3990 | 468
 | EmpID_180201194 | A | 1st_Quarter | 807 | 290 | 169 | 0 | 208 | 133 | 7034 | 3484 | 3357 | 0 | 2335 | 1205
 | EmpID_180201194 | A | 2nd_Quarter | 1386 | 402 | 241 | 433 | 48 | 55 | 13916 | 5428 | 2932 | 4712 | 738 | 882
 | EmpID_180201961 | B | 1st_Quarter | 617 | 440 | 122 | 125 | 95 | 75 | 7582 | 4865 | 1393 | 1035 | 1371 | 1009
 | EmpID_180201961 | B | 2nd_Quarter | 159 | 0 | 0 | 86 | 0 | 77 | 1834 | 0 | 0 | 855 | 0 | 389