Spreadsheet: 868215d1714973861-best-choice-to-get-desired-output-for-bulk-data-book12-7-aligw
Sheet: Output

 |  |  |  | Quantity |  |  |  |  |  | Revenue
 | IDs | Category | Period | Region-1 | [NAME] | Region-3 | Region-4 | Region-5 | Region-6 | Region-1 | [NAME] | Region-3 | Region-4 | Region-5 | Region-6
 | ID_110201307 | C | 1st_Quarter | 586 | 80 | 145 | 100 | 0 | 0 | 5154 | 1666 | 2273 | 352 | 0 | 0
 | ID_110201307 | C | 2nd_Quarter | 1392 | 267 | 170 | 67 | 14 | 0 | 15568 | 3323 | 2237 | 453 | 430 | 0
 | ID_120402038 | B | 1st_Quarter | 622 | 60 | 49 | 0 | 76 | 9 | 6593 | 938 | 195 | 0 | 285 | 470
 | ID_120402038 | B | 2nd_Quarter | 1424 | 180 | 160 | 69 | 49 | 0 | 17214 | 1954 | 2289 | 443 | 699 | 0
 | ID_130200761 | B | 1st_Quarter | 623 | 88 | 0 | 11 | 32 | 0 | 5875 | 827 | 0 | 987 | 458 | 0
 | ID_130201165 | C | 1st_Quarter | 641 | 89 | 104 | 158 | 0 | 0 | 5585 | 1411 | 1754 | 587 | 0 | 0
 | ID_130201165 | C | 2nd_Quarter | 1114 | 560 | 286 | 0 | 47 | 0 | 13822 | 4003 | 3046 | 0 | 897 | 0
 | ID_130400664 | B | 2nd_Quarter | 1051 | 259 | 439 | 0 | 20 | 0 | 10830 | 5364 | 5202 | 0 | 354 | 0
 | ID_130402435 | B | 1st_Quarter | 668 | 16 | 192 | 0 | 0 | 0 | 8115 | 623 | 897 | 0 | 0 | 0
 | ID_130402435 | B | 2nd_Quarter | 1600 | 369 | 121 | 26 | 104 | 0 | 16432 | 3173 | 1169 | 520 | 1229 | 0
 | ID_140403468 | C | 1st_Quarter | 517 | 129 | 55 | 72 | 63 | 0 | 6943 | 1724 | 806 | 938 | 399 | 0
 | ID_150200118 | C | 1st_Quarter | 474 | 125 | 206 | 26 | 58 | 0 | 5180 | 2050 | 1477 | 335 | 232 | 0
 | ID_150200118 | C | 2nd_Quarter | 1506 | 424 | 162 | 0 | 39 | 0 | 16510 | 4023 | 2368 | 0 | 584 | 0
 | ID_150400754 | C | 1st_Quarter | 589 | 319 | 0 | 0 | 0 | 0 | 6444 | 3030 | 0 | 0 | 0 | 0
 | ID_150400815 | B | 1st_Quarter | 542 | 262 | 66 | 0 | 26 | 0 | 6655 | 2022 | 467 | 0 | 672 | 0
 | ID_150402497 | C | 2nd_Quarter | 1119 | 474 | 247 | 12 | 73 | 58 | 10646 | 7002 | 2963 | 515 | 106 | 199
 | ID_150403859 | B | 1st_Quarter | 740 | 168 | 60 | 0 | 6 | 0 | 7045 | 1703 | 645 | 0 | 939 | 0
 | ID_150403859 | B | 2nd_Quarter | 1421 | 422 | 326 | 0 | 80 | 0 | 13644 | 4730 | 1892 | 0 | 929 | 0
 | ID_160200991 | B | 1st_Quarter | 504 | 211 | 69 | 0 | 1 | 90 | 5322 | 1862 | 299 | 0 | 332 | 733
 | ID_160201528 | C | 1st_Quarter | 557 | 189 | 68 | 44 | 0 | 0 | 7241 | 1476 | 975 | 675 | 0 | 0
 | ID_160201528 | C | 2nd_Quarter | 1410 | 358 | 187 | 23 | 137 | 0 | 13456 | 5731 | 1423 | 957 | 666 | 0
 | ID_160401403 | C | 1st_Quarter | 533 | 180 | 44 | 96 | 0 | 0 | 5949 | 1632 | 927 | 1396 | 0 | 0
 | ID_160401403 | C | 2nd_Quarter | 1321 | 402 | 274 | 85 | 60 | 0 | 14830 | 2273 | 2273 | 840 | 683 | 0
 | ID_160401509 | C | 1st_Quarter | 544 | 180 | 0 | 78 | 98 | 0 | 6462 | 2327 | 0 | 1006 | 772 | 0
 | ID_160401509 | C | 2nd_Quarter | 1241 | 409 | 18 | 0 | 85 | 0 | 18063 | 4019 | 1400 | 0 | 988 | 0
 | ID_160401749 | B | 1st_Quarter | 533 | 166 | 196 | 92 | 35 | 0 | 4143 | 545 | 2874 | 283 | 813 | 0
 | ID_160401749 | B | 2nd_Quarter | 1059 | 415 | 114 | 0 | 59 | 0 | 14388 | 4836 | 2846 | 0 | 224 | 0
 | ID_160401803 | B | 1st_Quarter | 702 | 7 | 52 | 65 | 0 | 54 | 6944 | 940 | 1133 | 721 | 0 | 706
 | ID_160401803 | B | 2nd_Quarter | 1415 | 529 | 225 | 64 | 193 | 0 | 12539 | 3490 | 2253 | 112 | 775 | 0
 | ID_160402065 | C | 1st_Quarter | 615 | 149 | 94 | 74 | 0 | 0 | 6646 | 1498 | 149 | 576 | 0 | 0
 | ID_160402065 | C | 2nd_Quarter | 1498 | 554 | 250 | 0 | 0 | 60 | 18686 | 3113 | 2156 | 0 | 0 | 360
 | ID_160402190 | C | 1st_Quarter | 724 | 144 | 215 | 35 | 0 | 0 | 6463 | 879 | 1977 | 266 | 0 | 0
 | ID_160402469 | C | 1st_Quarter | 698 | 159 | 0 | 0 | 0 | 0 | 7020 | 2617 | 0 | 0 | 0 | 0
 | ID_160402469 | C | 2nd_Quarter | 974 | 734 | 195 | 0 | 0 | 0 | 15233 | 5313 | 2565 | 0 | 0 | 0
 | ID_160402891 | C | 1st_Quarter | 622 | 112 | 0 | 54 | 0 | 35 | 8088 | 1913 | 0 | 235 | 0 | 652
 | ID_160402891 | C | 2nd_Quarter | 1093 | 794 | 184 | 87 | 0 | 0 | 11747 | 7627 | 960 | 129 | 0 | 0
 | ID_160403622 | B | 1st_Quarter | 704 | 199 | 23 | 70 | 0 | 0 | 4578 | 1400 | 706 | 456 | 0 | 0
 | ID_160403622 | B | 2nd_Quarter | 1688 | 356 | 85 | 0 | 0 | 25 | 15895 | 3030 | 871 | 0 | 0 | 534
 | ID_160403687 | D | 1st_Quarter | 675 | 156 | 19 | 0 | 0 | 0 | 7259 | 817 | 1031 | 0 | 0 | 0
 | ID_160403687 | D | 2nd_Quarter | 1543 | 428 | 256 | 42 | 0 | 0 | 11843 | 3948 | 2317 | 706 | 0 | 0
 | ID_160403818 | C | 1st_Quarter | 666 | 101 | 175 | 0 | 0 | 0 | 7648 | 2102 | 1805 | 0 | 0 | 0
 | ID_160404214 | B | 1st_Quarter | 699 | 123 | 6 | 71 | 0 | 0 | 8938 | 1459 | 381 | 565 | 0 | 0
 | ID_160404214 | B | 2nd_Quarter | 1270 | 364 | 139 | 88 | 0 | 0 | 12569 | 3832 | 1473 | 724 | 0 | 0
 | ID_170200915 | C | 1st_Quarter | 517 | 60 | 132 | 117 | 0 | 0 | 4798 | 1509 | 1624 | 1579 | 0 | 0
 | ID_170200915 | C | 2nd_Quarter | 1313 | 599 | 229 | 0 | 0 | 0 | 11905 | 5747 | 3284 | 0 | 0 | 0
 | ID_170200950 | B | 1st_Quarter | 616 | 164 | 0 | 53 | 0 | 0 | 9833 | 1146 | 0 | 700 | 0 | 0
 | ID_170201079 | C | 1st_Quarter | 400 | 296 | 196 | 71 | 0 | 0 | 4057 | 2365 | 2877 | 1475 | 0 | 0
 | ID_170201079 | C | 2nd_Quarter | 1115 | 646 | 288 | 4 | 0 | 0 | 13914 | 5939 | 2706 | 951 | 0 | 0
 | ID_170201179 | C | 1st_Quarter | 583 | 153 | 56 | 174 | 0 | 77 | 6921 | 474 | 198 | 760 | 0 | 748
 | ID_170201179 | C | 2nd_Quarter | 1473 | 423 | 186 | 0 | 0 | 0 | 13099 | 4206 | 1835 | 0 | 0 | 0
 | ID_170201315 | C | 1st_Quarter | 756 | 141 | 6 | 0 | 0 | 0 | 9254 | 1514 | 672 | 0 | 0 | 0
 | ID_170201315 | C | 2nd_Quarter | 966 | 558 | 513 | 0 | 0 | 60 | 9336 | 5882 | 6732 | 0 | 0 | 693
 | ID_170201438 | C | 1st_Quarter | 600 | 88 | 44 | 0 | 0 | 0 | 7179 | 2400 | 367 | 0 | 0 | 0
 | ID_170201438 | C | 2nd_Quarter | 1463 | 440 | 121 | 19 | 0 | 0 | 15424 | 4406 | 568 | 566 | 0 | 0
 | ID_170201716 | B | 1st_Quarter | 782 | 209 | 57 | 0 | 0 | 0 | 7846 | 1925 | 645 | 0 | 0 | 0
 | ID_170201716 | B | 2nd_Quarter | 1200 | 647 | 339 | 59 | 0 | 0 | 12789 | 6019 | 2676 | 807 | 0 | 0
 | ID_170201793 | C | 1st_Quarter | 737 | 109 | 61 | 0 | 0 | 0 | 7832 | 2259 | 616 | 0 | 0 | 0
 | ID_170201793 | C | 2nd_Quarter | 1154 | 440 | 292 | 90 | 0 | 0 | 14652 | 2853 | 4286 | 793 | 0 | 0
 | ID_170201883 | B | 2nd_Quarter | 1129 | 728 | 190 | 86 | 0 | 3 | 11824 | 3835 | 1299 | 124 | 0 | 347
 | ID_170202111 | D | 1st_Quarter | 577 | 341 | 0 | 0 | 0 | 0 | 7939 | 2216 | 0 | 0 | 0 | 0
 | ID_170202111 | D | 2nd_Quarter | 1481 | 210 | 174 | 170 | 0 | 0 | 16177 | 3510 | 3693 | 1072 | 0 | 0
 | ID_170202340 | D | 1st_Quarter | 719 | 180 | 61 | 0 | 0 | 0 | 6732 | 970 | 556 | 0 | 0 | 0
 | ID_170202353 | C | 1st_Quarter | 602 | 167 | 19 | 0 | 0 | 0 | 6154 | 1517 | 468 | 0 | 0 | 0
 | ID_170202353 | C | 2nd_Quarter | 1729 | 202 | 61 | 0 | 0 | 17 | 19330 | 3044 | 1234 | 0 | 0 | 846
 | ID_170202394 | C | 1st_Quarter | 629 | 306 | 50 | 0 | 0 | 0 | 5783 | 3869 | 811 | 0 | 0 | 0
 | ID_170202394 | C | 2nd_Quarter | 1545 | 467 | 222 | 48 | 0 | 80 | 15754 | 2726 | 1429 | 407 | 0 | 929
 | ID_170202531 | C | 1st_Quarter | 597 | 290 | 0 | 0 | 0 | 0 | 6614 | 4683 | 0 | 0 | 0 | 0
 | ID_170202531 | C | 2nd_Quarter | 1079 | 557 | 200 | 35 | 0 | 0 | 14558 | 5040 | 2253 | 1279 | 0 | 0
 | ID_170202557 | A | 1st_Quarter | 389 | 146 | 154 | 53 | 0 | 0 | 4900 | 1953 | 1758 | 979 | 0 | 0
 | ID_170202687 | C | 1st_Quarter | 802 | 172 | 25 | 0 | 0 | 0 | 7168 | 2062 | 378 | 0 | 0 | 0
 | ID_170202687 | C | 2nd_Quarter | 1413 | 408 | 28 | 51 | 0 | 0 | 14992 | 3389 | 460 | 197 | 0 | 0
 | ID_170203133 | D | 1st_Quarter | 595 | 96 | 213 | 0 | 0 | 0 | 4781 | 225 | 2550 | 0 | 0 | 0
 | ID_170203133 | D | 2nd_Quarter | 1394 | 554 | 87 | 0 | 0 | 0 | 14851 | 6878 | 1221 | 0 | 0 | 0
 | ID_170400050 | A | 1st_Quarter | 716 | 47 | 75 | 45 | 0 | 0 | 7131 | 928 | 751 | 484 | 0 | 0
 | ID_170400050 | A | 2nd_Quarter | 1502 | 275 | 289 | 0 | 0 | 0 | 13267 | 3373 | 4161 | 0 | 0 | 0
 | ID_170400359 | D | 2nd_Quarter | 1324 | 178 | 113 | 208 | 0 | 10 | 14673 | 2663 | 1097 | 1762 | 0 | 855
 | ID_170400390 | B | 2nd_Quarter | 1537 | 321 | 161 | 0 | 0 | 0 | 18167 | 4287 | 1057 | 0 | 0 | 0
 | ID_170400420 | C | 1st_Quarter | 692 | 74 | 133 | 50 | 0 | 0 | 5742 | 767 | 2374 | 667 | 0 | 0
 | ID_170400420 | C | 2nd_Quarter | 1404 | 428 | 181 | 0 | 0 | 0 | 14661 | 5423 | 1348 | 0 | 0 | 0
 | ID_170400665 | B | 1st_Quarter | 750 | 266 | 19 | 89 | 0 | 0 | 6708 | 1524 | 541 | 410 | 0 | 0
 | ID_170401098 | C | 1st_Quarter | 553 | 143 | 0 | 233 | 0 | 0 | 6453 | 1600 | 0 | 2623 | 0 | 0
 | ID_170401098 | C | 2nd_Quarter | 1439 | 454 | 320 | 89 | 0 | 0 | 13878 | 4722 | 3220 | 395 | 0 | 0
 | ID_170401212 | B | 1st_Quarter | 628 | 261 | 73 | 0 | 0 | 0 | 7684 | 1249 | 414 | 0 | 0 | 0
 | ID_170401212 | B | 2nd_Quarter | 1508 | 430 | 131 | 30 | 0 | 0 | 15513 | 4225 | 830 | 406 | 0 | 0
 | [NAME] | C | 1st_Quarter | 381 | 388 | 0 | 183 | 0 | 0 | 5206 | 3688 | 0 | 867 | 0 | 0
 | [NAME] | C | 2nd_Quarter | 1210 | 494 | 197 | 45 | 0 | 0 | 12154 | 4170 | 2801 | 456 | 0 | 0
 | ID_170401559 | B | 1st_Quarter | 469 | 123 | 137 | 93 | 0 | 0 | 6195 | 1616 | 1826 | 850 | 0 | 0
 | ID_170401559 | B | 2nd_Quarter | 1544 | 433 | 76 | 78 | 0 | 0 | 18372 | 4401 | 905 | 881 | 0 | 0
 | ID_170401634 | C | 1st_Quarter | 736 | 350 | 74 | 0 | 0 | 0 | 7474 | 1841 | 465 | 0 | 0 | 0
 | ID_170401634 | C | 2nd_Quarter | 1447 | 515 | 117 | 67 | 0 | 0 | 17083 | 4167 | 1346 | 792 | 0 | 0
 | ID_170401804 | B | 1st_Quarter | 711 | 134 | 0 | 0 | 0 | 0 | 7030 | 2513 | 0 | 0 | 0 | 0
 | ID_170401822 | C | 1st_Quarter | 635 | 110 | 0 | 0 | 0 | 12 | 7386 | 3146 | 0 | 0 | 0 | 883
 | ID_170401822 | C | 2nd_Quarter | 1413 | 329 | 37 | 86 | 0 | 0 | 17773 | 5911 | 1283 | 1310 | 0 | 0
 | ID_170401884 | C | 1st_Quarter | 626 | 39 | 38 | 155 | 0 | 0 | 7307 | 544 | 388 | 904 | 0 | 0
 | ID_170401884 | C | 2nd_Quarter | 1623 | 618 | 137 | 0 | 0 | 0 | 17599 | 4454 | 1078 | 0 | 0 | 0
 | ID_170402595 | B | 1st_Quarter | 766 | 188 | 0 | 39 | 0 | 0 | 8065 | 1463 | 0 | 783 | 0 | 0
 | ID_170402595 | B | 2nd_Quarter | 1148 | 553 | 194 | 96 | 0 | 0 | 12506 | 6019 | 3660 | 747 | 0 | 0
 | ID_170402614 | C | 2nd_Quarter | 1480 | 381 | 214 | 38 | 0 | 0 | 13313 | 3806 | 3720 | 525 | 0 | 0
 | ID_170402783 | D | 1st_Quarter | 355 | 327 | 82 | 24 | 0 | 77 | 2987 | 3187 | 173 | 780 | 0 | 186
 | ID_170402783 | D | 2nd_Quarter | 1143 | 487 | 293 | 153 | 0 | 0 | 13992 | 4264 | 4553 | 575 | 0 | 0
 | ID_170402973 | C | 1st_Quarter | 698 | 101 | 100 | 68 | 0 | 0 | 8787 | 509 | 1673 | 319 | 0 | 0
 | ID_170402973 | C | 2nd_Quarter | 1464 | 327 | 235 | 99 | 0 | 52 | 15427 | 4102 | 2012 | 729 | 0 | 231
 | ID_170403248 | C | 1st_Quarter | 607 | 300 | 85 | 0 | 0 | 0 | 7454 | 1555 | 196 | 0 | 0 | 0
 | ID_170403248 | C | 2nd_Quarter | 1415 | 284 | 248 | 0 | 0 | 0 | 15253 | 3780 | 2310 | 0 | 0 | 0
 | ID_170403267 | D | 1st_Quarter | 559 | 146 | 155 | 0 | 0 | 88 | 5678 | 1953 | 1686 | 0 | 0 | 153
 | ID_170403267 | D | 2nd_Quarter | 1613 | 569 | 43 | 0 | 0 | 0 | 14558 | 3779 | 1987 | 0 | 0 | 0
 | ID_170403270 | C | 1st_Quarter | 448 | 141 | 163 | 110 | 0 | 0 | 4451 | 558 | 2588 | 1414 | 0 | 0
 | ID_170403618 | B | 1st_Quarter | 571 | 64 | 121 | 90 | 0 | 0 | 4622 | 910 | 1428 | 639 | 0 | 0
 | ID_170403618 | B | 2nd_Quarter | 1328 | 352 | 77 | 67 | 0 | 0 | 15122 | 4829 | 2461 | 1325 | 0 | 0
 | ID_170403779 | B | 1st_Quarter | 439 | 111 | 0 | 0 | 0 | 81 | 6830 | 2058 | 0 | 0 | 0 | 273
 | ID_170403779 | B | 2nd_Quarter | 1225 | 301 | 318 | 62 | 0 | 0 | 14086 | 1914 | 4226 | 879 | 0 | 0
 | ID_170403786 | D | 1st_Quarter | 820 | 57 | 90 | 0 | 0 | 94 | 7224 | 975 | 1579 | 0 | 0 | 360
 | ID_170403786 | D | 2nd_Quarter | 1525 | 439 | 208 | 45 | 0 | 0 | 16248 | 4645 | 2375 | 199 | 0 | 0
 | ID_170403866 | C | 1st_Quarter | 703 | 83 | 0 | 81 | 0 | 0 | 6742 | 1448 | 0 | 275 | 0 | 0
 | ID_170403866 | C | 2nd_Quarter | 1314 | 230 | 231 | 6 | 0 | 0 | 15052 | 2673 | 3495 | 642 | 0 | 0
 | ID_170403869 | C | 1st_Quarter | 688 | 201 | 94 | 0 | 0 | 0 | 7060 | 2356 | 1073 | 0 | 0 | 0
 | ID_170403870 | C | 1st_Quarter | 489 | 98 | 56 | 93 | 0 | 79 | 8012 | 1856 | 376 | 879 | 0 | 370
 | ID_170403870 | C | 2nd_Quarter | 1587 | 442 | 272 | 0 | 0 | 0 | 14276 | 4606 | 1900 | 0 | 0 | 0
 | ID_170403964 | B | 1st_Quarter | 567 | 140 | 148 | 37 | 0 | 0 | 6047 | 1392 | 1577 | 724 | 0 | 0
 | ID_170403964 | B | 2nd_Quarter | 1445 | 631 | 219 | 0 | 0 | 0 | 15210 | 6884 | 2502 | 0 | 0 | 0
 | ID_170404169 | C | 1st_Quarter | 728 | 145 | 80 | 0 | 0 | 0 | 8590 | 1341 | 1661 | 0 | 0 | 0
 | ID_170404169 | C | 2nd_Quarter | 1605 | 361 | 229 | 67 | 0 | 0 | 16413 | 5667 | 2221 | 1152 | 0 | 0
 | ID_170404210 | B | 1st_Quarter | 874 | 17 | 56 | 0 | 0 | 0 | 7325 | 627 | 468 | 0 | 0 | 0
 | ID_170404210 | B | 2nd_Quarter | 1427 | 280 | 98 | 0 | 0 | 0 | 15281 | 3574 | 755 | 0 | 0 | 0
 | ID_170404299 | C | 1st_Quarter | 595 | 231 | 0 | 95 | 0 | 12 | 5959 | 1891 | 0 | 793 | 0 | 736
 | ID_170404299 | C | 2nd_Quarter | 1552 | 261 | 307 | 132 | 0 | 0 | 15834 | 2589 | 3525 | 1000 | 0 | 0
 | ID_170404370 | B | 1st_Quarter | 719 | 249 | 74 | 173 | 0 | 0 | 6879 | 1775 | 1427 | 653 | 0 | 0
 | ID_170404370 | B | 2nd_Quarter | 1298 | 225 | 125 | 38 | 0 | 54 | 15053 | 4722 | 1811 | 609 | 0 | 235
 | ID_170404523 | C | 1st_Quarter | 590 | 108 | 31 | 82 | 0 | 40 | 5083 | 1821 | 936 | 737 | 0 | 241
 | ID_170404523 | C | 2nd_Quarter | 1631 | 236 | 121 | 97 | 0 | 35 | 17751 | 1851 | 845 | 906 | 0 | 219
 | ID_170404918 | C | 1st_Quarter | 542 | 9 | 58 | 25 | 0 | 42 | 5780 | 156 | 836 | 827 | 0 | 780
 | ID_170404918 | C | 2nd_Quarter | 1270 | 575 | 244 | 0 | 0 | 0 | 13221 | 5952 | 2563 | 0 | 0 | 0
 | ID_170405300 | C | 1st_Quarter | 718 | 182 | 0 | 69 | 0 | 100 | 6726 | 2892 | 0 | 451 | 0 | 270
 | ID_170405300 | C | 2nd_Quarter | 1687 | 369 | 176 | 85 | 0 | 0 | 14621 | 3606 | 2535 | 235 | 0 | 0
 | ID_170405383 | B | 1st_Quarter | 703 | 376 | 42 | 0 | 0 | 0 | 5496 | 4291 | 954 | 0 | 0 | 0
 | ID_170405385 | C | 1st_Quarter | 44 | 0 | 0 | 0 | 0 | 0 | 990 | 0 | 0 | 0 | 0 | 0