Spreadsheet: 126114d1319533228-excel-2007-pivot-table-convert-dd-mm-yyyy-to-mm-yyyy-copy1
Sheet: date

SKU | Description | Qty | Group date | Date
1 |  | 48 |  | 2011-10-12 00:00:00
2 |  | 345 |  | 2011-10-20 00:00:00
3 |  | 36 |  | 2011-10-31 00:00:00
4 |  | 252 |  | 2011-11-11 00:00:00 |  |  | Sum of Qty |  | Column Labels
5 |  | 288 |  | 2012-01-01 00:00:00 |  |  | Row Labels | Description | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | Grand Total
6 |  | 72 |  | 2012-01-01 00:00:00 |  |  | 1 | (blank) | 48 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48
7 |  | 500 |  | 2012-01-09 00:00:00 |  |  | 2 | (blank) | 345 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 345
8 |  | 588 |  | 2012-01-09 00:00:00 |  |  | 3 | (blank) | 36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36
9 |  | 576 |  | 2012-01-14 00:00:00 |  |  | 4 | (blank) |  | 252 |  |  |  |  |  |  |  |  |  |  |  |  |  | 252
10 |  | 1008 |  | 2012-01-16 00:00:00 |  |  | 5 | (blank) |  |  |  | 288 |  |  |  |  |  |  |  |  |  |  |  | 288
11 |  | 684 |  | 2012-01-16 00:00:00 |  |  | 6 | (blank) |  |  |  | 72 |  |  |  |  |  |  |  |  |  |  |  | 72
12 |  | 322 |  | 2012-01-22 00:00:00 |  |  | 7 | (blank) |  |  |  | 500 |  |  |  |  |  |  |  |  |  |  |  | 500
13 |  | 720 |  | 2012-01-26 00:00:00 |  |  | 8 | (blank) |  |  |  | 588 |  |  |  |  |  |  |  |  |  |  |  | 588
14 |  | 379 |  | 2012-01-31 00:00:00 |  |  | 9 | (blank) |  |  |  | 576 |  |  |  |  |  |  |  |  |  |  |  | 576
15 |  | 156 |  | 2012-02-01 00:00:00 |  |  | 10 | (blank) |  |  |  | 1008 |  |  |  |  |  |  |  |  |  |  |  | 1008
16 |  | 60 |  | 2012-02-01 00:00:00 |  |  | 11 | (blank) |  |  |  | 684 |  |  |  |  |  |  |  |  |  |  |  | 684
17 |  | 172 |  | 2012-02-05 00:00:00 |  |  | 12 | (blank) |  |  |  | 322 |  |  |  |  |  |  |  |  |  |  |  | 322
18 |  | 496 |  | 2012-02-10 00:00:00 |  |  | 13 | (blank) |  |  |  | 720 |  |  |  |  |  |  |  |  |  |  |  | 720
19 |  | 520 |  | 2012-02-12 00:00:00 |  |  | 14 | (blank) |  |  |  | 379 |  |  |  |  |  |  |  |  |  |  |  | 379
20 |  | 38 |  | 2012-02-12 00:00:00 |  |  | 15 | (blank) |  |  |  |  | 156 |  |  |  |  |  |  |  |  |  |  | 156
21 |  | 221 |  | 2012-02-17 00:00:00 |  |  | 16 | (blank) |  |  |  |  | 60 |  |  |  |  |  |  |  |  |  |  | 60
22 |  | 60 |  | 2012-03-04 00:00:00 |  |  | 17 | (blank) |  |  |  |  | 172 |  |  |  |  |  |  |  |  |  |  | 172
23 |  | 570 |  | 2012-03-04 00:00:00 |  |  | 18 | (blank) |  |  |  |  | 496 |  |  |  |  |  |  |  |  |  |  | 496
24 |  | 288 |  | 2012-03-06 00:00:00 |  |  | 19 | (blank) |  |  |  |  | 520 |  |  |  |  |  |  |  |  |  |  | 520
25 |  | 192 |  | 2012-03-06 00:00:00 |  |  | 20 | (blank) |  |  |  |  | 38 |  |  |  |  |  |  |  |  |  |  | 38
26 |  | 24 |  | 2012-03-10 00:00:00 |  |  | 21 | (blank) |  |  |  |  | 221 |  |  |  |  |  |  |  |  |  |  | 221
27 |  | 612 |  | 2012-03-11 00:00:00 |  |  | 22 | (blank) |  |  |  |  |  | 60 |  |  |  |  |  |  |  |  |  | 60
28 |  | 576 |  | 2012-03-12 00:00:00 |  |  | 23 | (blank) |  |  |  |  |  | 570 |  |  |  |  |  |  |  |  |  | 570
29 |  | 264 |  | 2012-03-12 00:00:00 |  |  | 24 | (blank) |  |  |  |  |  | 288 |  |  |  |  |  |  |  |  |  | 288
30 |  | 600 |  | 2012-03-13 00:00:00 |  |  | 25 | (blank) |  |  |  |  |  | 192 |  |  |  |  |  |  |  |  |  | 192
31 |  | 108 |  | 2012-03-30 00:00:00 |  |  | 26 | (blank) |  |  |  |  |  | 24 |  |  |  |  |  |  |  |  |  | 24
32 |  | 960 |  | 2012-03-31 00:00:00 |  |  | 27 | (blank) |  |  |  |  |  | 612 |  |  |  |  |  |  |  |  |  | 612
33 |  | 300 |  | 2012-04-01 00:00:00 |  |  | 28 | (blank) |  |  |  |  |  | 576 |  |  |  |  |  |  |  |  |  | 576
34 |  | 521 |  | 2012-04-06 00:00:00 |  |  | 29 | (blank) |  |  |  |  |  | 264 |  |  |  |  |  |  |  |  |  | 264
35 |  | 612 |  | 2012-04-07 00:00:00 |  |  | 30 | (blank) |  |  |  |  |  | 600 |  |  |  |  |  |  |  |  |  | 600
36 |  | 660 |  | 2012-04-08 00:00:00 |  |  | 31 | (blank) |  |  |  |  |  | 108 |  |  |  |  |  |  |  |  |  | 108
37 |  | 625 |  | 2012-04-10 00:00:00 |  |  | 32 | (blank) |  |  |  |  |  | 960 |  |  |  |  |  |  |  |  |  | 960
38 |  | 880 |  | 2012-04-27 00:00:00 |  |  | 33 | (blank) |  |  |  |  |  |  | 300 |  |  |  |  |  |  |  |  | 300
39 |  | 360 |  | 2012-04-27 00:00:00 |  |  | 34 | (blank) |  |  |  |  |  |  | 521 |  |  |  |  |  |  |  |  | 521
40 |  | 465 |  | 2012-04-29 00:00:00 |  |  | 35 | (blank) |  |  |  |  |  |  | 612 |  |  |  |  |  |  |  |  | 612
41 |  | 304 |  | 2012-04-30 00:00:00 |  |  | 36 | (blank) |  |  |  |  |  |  | 660 |  |  |  |  |  |  |  |  | 660
42 |  | 144 |  | 2012-05-01 00:00:00 |  |  | 37 | (blank) |  |  |  |  |  |  | 625 |  |  |  |  |  |  |  |  | 625
43 |  | 660 |  | 2012-05-02 00:00:00 |  |  | 38 | (blank) |  |  |  |  |  |  | 880 |  |  |  |  |  |  |  |  | 880
44 |  | 1620 |  | 2012-05-09 00:00:00 |  |  | 39 | (blank) |  |  |  |  |  |  | 360 |  |  |  |  |  |  |  |  | 360
45 |  | 396 |  | 2012-05-09 00:00:00 |  |  | 40 | (blank) |  |  |  |  |  |  | 465 |  |  |  |  |  |  |  |  | 465
46 |  | 300 |  | 2012-05-13 00:00:00 |  |  | 41 | (blank) |  |  |  |  |  |  | 304 |  |  |  |  |  |  |  |  | 304
47 |  | 528 |  | 2012-05-20 00:00:00 |  |  | 42 | (blank) |  |  |  |  |  |  |  | 144 |  |  |  |  |  |  |  | 144
48 |  | 625 |  | 2012-05-27 00:00:00 |  |  | 43 | (blank) |  |  |  |  |  |  |  | 660 |  |  |  |  |  |  |  | 660
49 |  | 625 |  | 2012-05-27 00:00:00 |  |  | 44 | (blank) |  |  |  |  |  |  |  | 1620 |  |  |  |  |  |  |  | 1620
50 |  | 625 |  | 2012-05-27 00:00:00 |  |  | 45 | (blank) |  |  |  |  |  |  |  | 396 |  |  |  |  |  |  |  | 396
51 |  | 625 |  | 2012-05-27 00:00:00 |  |  | 46 | (blank) |  |  |  |  |  |  |  | 300 |  |  |  |  |  |  |  | 300
52 |  | 625 |  | 2012-05-27 00:00:00 |  |  | 47 | (blank) |  |  |  |  |  |  |  | 528 |  |  |  |  |  |  |  | 528
53 |  | 625 |  | 2012-05-27 00:00:00 |  |  | 48 | (blank) |  |  |  |  |  |  |  | 625 |  |  |  |  |  |  |  | 625
54 |  | 625 |  | 2012-05-27 00:00:00 |  |  | 49 | (blank) |  |  |  |  |  |  |  | 625 |  |  |  |  |  |  |  | 625
55 |  | 625 |  | 2012-05-27 00:00:00 |  |  | 50 | (blank) |  |  |  |  |  |  |  | 625 |  |  |  |  |  |  |  | 625
56 |  | 625 |  | 2012-05-27 00:00:00 |  |  | 51 | (blank) |  |  |  |  |  |  |  | 625 |  |  |  |  |  |  |  | 625
57 |  | 625 |  | 2012-05-27 00:00:00 |  |  | 52 | (blank) |  |  |  |  |  |  |  | 625 |  |  |  |  |  |  |  | 625
58 |  | 625 |  | 2012-05-27 00:00:00 |  |  | 53 | (blank) |  |  |  |  |  |  |  | 625 |  |  |  |  |  |  |  | 625
59 |  | 625 |  | 2012-05-27 00:00:00 |  |  | 54 | (blank) |  |  |  |  |  |  |  | 625 |  |  |  |  |  |  |  | 625
60 |  | 625 |  | 2012-05-27 00:00:00 |  |  | 55 | (blank) |  |  |  |  |  |  |  | 625 |  |  |  |  |  |  |  | 625
61 |  | 625 |  | 2012-05-27 00:00:00 |  |  | 56 | (blank) |  |  |  |  |  |  |  | 625 |  |  |  |  |  |  |  | 625
62 |  | 625 |  | 2012-05-27 00:00:00 |  |  | 57 | (blank) |  |  |  |  |  |  |  | 625 |  |  |  |  |  |  |  | 625
63 |  | 683 |  | 2012-05-27 00:00:00 |  |  | 58 | (blank) |  |  |  |  |  |  |  | 625 |  |  |  |  |  |  |  | 625
64 |  | 528 |  | 2012-05-31 00:00:00 |  |  | 59 | (blank) |  |  |  |  |  |  |  | 625 |  |  |  |  |  |  |  | 625
65 |  | 912 |  | 2012-05-31 00:00:00 |  |  | 60 | (blank) |  |  |  |  |  |  |  | 625 |  |  |  |  |  |  |  | 625
66 |  | 330 |  | 2012-06-06 00:00:00 |  |  | 61 | (blank) |  |  |  |  |  |  |  | 625 |  |  |  |  |  |  |  | 625
67 |  | 800 |  | 2012-06-19 00:00:00 |  |  | 62 | (blank) |  |  |  |  |  |  |  | 625 |  |  |  |  |  |  |  | 625
68 |  | 1560 |  | 2012-06-20 00:00:00 |  |  | 63 | (blank) |  |  |  |  |  |  |  | 683 |  |  |  |  |  |  |  | 683
69 |  | 419 |  | 2012-06-22 00:00:00 |  |  | 64 | (blank) |  |  |  |  |  |  |  | 528 |  |  |  |  |  |  |  | 528
70 |  | 378 |  | 2012-06-30 00:00:00 |  |  | 65 | (blank) |  |  |  |  |  |  |  | 912 |  |  |  |  |  |  |  | 912
71 |  | 220 |  | 2012-06-30 00:00:00 |  |  | 66 | (blank) |  |  |  |  |  |  |  |  | 330 |  |  |  |  |  |  | 330
72 |  | 270 |  | 2012-06-30 00:00:00 |  |  | 67 | (blank) |  |  |  |  |  |  |  |  | 800 |  |  |  |  |  |  | 800
73 |  | 1680 |  | 2012-07-05 00:00:00 |  |  | 68 | (blank) |  |  |  |  |  |  |  |  | 1560 |  |  |  |  |  |  | 1560
74 |  | 517 |  | 2012-07-05 00:00:00 |  |  | 69 | (blank) |  |  |  |  |  |  |  |  | 419 |  |  |  |  |  |  | 419
75 |  | 306 |  | 2012-07-09 00:00:00 |  |  | 70 | (blank) |  |  |  |  |  |  |  |  | 378 |  |  |  |  |  |  | 378
76 |  | 800 |  | 2012-07-25 00:00:00 |  |  | 71 | (blank) |  |  |  |  |  |  |  |  | 220 |  |  |  |  |  |  | 220
77 |  | 375 |  | 2012-08-22 00:00:00 |  |  | 72 | (blank) |  |  |  |  |  |  |  |  | 270 |  |  |  |  |  |  | 270
78 |  | 2 |  | 2012-09-30 00:00:00 |  |  | 73 | (blank) |  |  |  |  |  |  |  |  |  | 1680 |  |  |  |  |  | 1680
79 |  | 840 |  | 2012-10-11 00:00:00 |  |  | 74 | (blank) |  |  |  |  |  |  |  |  |  | 517 |  |  |  |  |  | 517
80 |  | 780 |  | 2012-10-11 00:00:00 |  |  | 75 | (blank) |  |  |  |  |  |  |  |  |  | 306 |  |  |  |  |  | 306
81 |  | 301 |  | 2012-11-11 00:00:00 |  |  | 76 | (blank) |  |  |  |  |  |  |  |  |  | 800 |  |  |  |  |  | 800
82 |  | 432 |  | 2012-11-24 00:00:00 |  |  | 77 | (blank) |  |  |  |  |  |  |  |  |  |  | 375 |  |  |  |  | 375
83 |  | 1560 |  | 2012-12-11 00:00:00 |  |  | 78 | (blank) |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | 2
84 |  | 1680 |  | 2012-12-14 00:00:00 |  |  | 79 | (blank) |  |  |  |  |  |  |  |  |  |  |  |  | 840 |  |  | 840
85 |  | 608 |  | 2012-12-14 00:00:00 |  |  | 80 | (blank) |  |  |  |  |  |  |  |  |  |  |  |  | 780 |  |  | 780
86 |  | 440 |  | 2011-12-25 00:00:00 |  |  | 81 | (blank) |  |  |  |  |  |  |  |  |  |  |  |  |  | 301 |  | 301
87 |  | 0 |  | 00:00:00 |  |  | 82 | (blank) |  |  |  |  |  |  |  |  |  |  |  |  |  | 432 |  | 432
 |  |  |  |  |  |  | 83 | (blank) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1560 | 1560
 |  |  |  |  |  |  | 84 | (blank) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1680 | 1680
 |  |  |  |  |  |  | 85 | (blank) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 608 | 608
 |  |  |  |  |  |  | 86 | (blank) |  |  | 440 |  |  |  |  |  |  |  |  |  |  |  |  | 440
 |  |  |  |  |  |  | Grand Total |  | 429 | 252 | 440 | 5137 | 1663 | 4254 | 4727 | 15146 | 3977 | 3303 | 375 | 2 | 1620 | 733 | 3848 | 45906