Spreadsheet: 165748d1341331320-creating-a-macro-to-rearrange-data-samplebook2
Sheet: Before

 |  | Delivery Month
 | 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 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00 | 2017-01-01 00:00:00 | 2017-02-01 00:00:00 | 2017-03-01 00:00:00 | 2017-04-01 00:00:00 | 2017-05-01 00:00:00 | 2017-06-01 00:00:00 | 2017-07-01 00:00:00 | 2017-08-01 00:00:00 | 2017-09-01 00:00:00 | 2017-10-01 00:00:00 | 2017-11-01 00:00:00 | 2017-12-01 00:00:00 | 2018-01-01 00:00:00 | 2018-02-01 00:00:00 | 2018-03-01 00:00:00 | 2018-04-01 00:00:00 | 2018-05-01 00:00:00 | 2018-06-01 00:00:00 | 2018-07-01 00:00:00 | 2018-08-01 00:00:00 | 2018-09-01 00:00:00 | 2018-10-01 00:00:00 | 2018-11-01 00:00:00 | 2018-12-01 00:00:00
Item A | 77 | 71 | 44 | 90 | 9 | 37 | 44 | 64 | 2 | 97 | 86 | 28 | 18 | 35 | 71 | 13 | 60 | 33 | 59 | 75 | 19 | 66 | 20 | 37 | 62 | 45 | 22 | 80 | 73 | 75 | 4 | 44 | 98 | 6 | 37 | 75 | 86 | 39 | 53 | 44 | 83 | 100 | 4 | 81 | 98 | 87 | 63 | 62 | 18 | 69 | 36 | 31 | 28 | 27 | 5 | 75 | 72 | 84 | 15 | 71 | 10 | 56 | 63 | 48 | 73 | 51 | 60 | 15 | 55 | 77 | 52 | 65 | 28 | 7 | 74 | 38 | 47 | 74 | 45 | 17 | 19 | 91 | 49 | 6
Item B | 67 | 79 | 69 | 20 | 70 | 96 | 13 | 22 | 28 | 61 | 11 | 61 | 39 | 31 | 95 | 31 | 29 | 84 | 13 | 77 | 20 | 2 | 4 | 34 | 3 | 80 | 99 | 10 | 56 | 19 | 78 | 80 | 53 | 26 | 56 | 68 | 2 | 70 | 32 | 53 | 57 | 75 | 3 | 17 | 73 | 97 | 76 | 19 | 78 | 85 | 53 | 38 | 21 | 90 | 22 | 69 | 86 | 55 | 77 | 22 | 92 | 43 | 23 | 47 | 2 | 50 | 85 | 88 | 55 | 85 | 36 | 56 | 67 | 45 | 21 | 99 | 49 | 17 | 2 | 69 | 41 | 46 | 15 | 38
Item C | 97 | 27 | 73 | 74 | 45 | 11 | 44 | 68 | 98 | 12 | 43 | 79 | 53 | 9 | 44 | 40 | 39 | 15 | 80 | 24 | 37 | 82 | 53 | 79 | 15 | 52 | 30 | 92 | 40 | 72 | 3 | 64 | 89 | 5 | 19 | 36 | 1 | 22 | 51 | 3 | 16 | 92 | 13 | 88 | 72 | 80 | 10 | 74 | 66 | 40 | 2 | 36 | 20 | 50 | 74 | 10 | 15 | 34 | 96 | 84 | 90 | 39 | 39 | 47 | 91 | 2 | 34 | 23 | 42 | 31 | 46 | 91 | 40 | 79 | 70 | 71 | 97 | 80 | 21 | 16 | 89 | 25 | 9 | 95
Item D | 27 | 72 | 51 | 88 | 20 | 36 | 58 | 9 | 19 | 40 | 46 | 14 | 25 | 38 | 98 | 11 | 75 | 57 | 19 | 38 | 61 | 83 | 74 | 10 | 60 | 8 | 18 | 12 | 66 | 63 | 95 | 22 | 16 | 85 | 59 | 65 | 51 | 6 | 81 | 5 | 83 | 89 | 49 | 95 | 56 | 95 | 36 | 65 | 23 | 71 | 71 | 46 | 39 | 88 | 54 | 97 | 94 | 11 | 2 | 89 | 67 | 93 | 28 | 28 | 63 | 54 | 4 | 77 | 36 | 18 | 60 | 39 | 78 | 99 | 82 | 49 | 88 | 40 | 14 | 88 | 70 | 85 | 65 | 36
Item E | 43 | 45 | 96 | 6 | 23 | 20 | 28 | 71 | 38 | 71 | 65 | 58 | 69 | 56 | 1 | 94 | 100 | 39 | 31 | 73 | 50 | 27 | 32 | 21 | 59 | 31 | 82 | 12 | 73 | 60 | 91 | 36 | 44 | 56 | 98 | 100 | 69 | 51 | 25 | 100 | 10 | 90 | 74 | 20 | 82 | 76 | 55 | 12 | 80 | 12 | 44 | 26 | 54 | 74 | 67 | 69 | 70 | 87 | 59 | 58 | 17 | 49 | 31 | 17 | 67 | 53 | 57 | 58 | 30 | 43 | 31 | 99 | 77 | 24 | 74 | 63 | 16 | 57 | 67 | 77 | 49 | 99 | 46 | 8
[NAME] | 30 | 62 | 68 | 29 | 66 | 32 | 72 | 85 | 55 | 55 | 58 | 14 | 70 | 48 | 70 | 97 | 46 | 96 | 61 | 76 | 78 | 61 | 68 | 22 | 61 | 55 | 30 | 64 | 53 | 29 | 93 | 79 | 26 | 83 | 47 | 26 | 16 | 61 | 8 | 48 | 37 | 54 | 66 | 37 | 88 | 76 | 52 | 71 | 63 | 83 | 2 | 57 | 7 | 49 | 61 | 11 | 16 | 37 | 61 | 59 | 100 | 53 | 23 | 77 | 63 | 28 | 8 | 34 | 99 | 28 | 15 | 59 | 11 | 15 | 42 | 95 | 96 | 82 | 96 | 19 | 49 | 76 | 43 | 80
Item G | 49 | 68 | 14 | 51 | 71 | 59 | 60 | 85 | 58 | 24 | 48 | 46 | 51 | 88 | 63 | 35 | 42 | 44 | 85 | 1 | 98 | 31 | 32 | 31 | 15 | 22 | 3 | 61 | 38 | 7 | 56 | 30 | 28 | 55 | 64 | 11 | 95 | 74 | 27 | 100 | 99 | 8 | 24 | 15 | 32 | 59 | 21 | 62 | 43 | 87 | 49 | 27 | 57 | 8 | 3 | 5 | 45 | 57 | 63 | 66 | 5 | 34 | 58 | 7 | 44 | 54 | 4 | 48 | 68 | 27 | 10 | 91 | 55 | 62 | 3 | 22 | 93 | 82 | 11 | 88 | 86 | 11 | 37 | 69
Item H | 44 | 26 | 12 | 26 | 29 | 74 | 65 | 48 | 28 | 57 | 27 | 93 | 86 | 21 | 64 | 49 | 83 | 45 | 66 | 22 | 99 | 2 | 98 | 5 | 38 | 70 | 35 | 95 | 24 | 42 | 14 | 10 | 16 | 13 | 43 | 51 | 41 | 21 | 65 | 71 | 66 | 54 | 28 | 97 | 16 | 86 | 71 | 77 | 29 | 55 | 68 | 84 | 26 | 36 | 100 | 62 | 5 | 67 | 48 | 14 | 3 | 54 | 55 | 60 | 75 | 92 | 32 | 59 | 15 | 20 | 42 | 99 | 59 | 94 | 25 | 90 | 54 | 22 | 1 | 19 | 49 | 25 | 49 | 1
Item I | 80 | 14 | 40 | 54 | 96 | 42 | 33 | 64 | 62 | 70 | 36 | 78 | 36 | 43 | 56 | 75 | 69 | 99 | 78 | 28 | 84 | 5 | 94 | 50 | 65 | 93 | 38 | 2 | 27 | 6 | 56 | 18 | 62 | 56 | 87 | 99 | 52 | 37 | 80 | 11 | 12 | 77 | 55 | 93 | 1 | 23 | 83 | 100 | 24 | 89 | 79 | 80 | 72 | 7 | 38 | 6 | 81 | 22 | 6 | 71 | 2 | 17 | 70 | 79 | 37 | 93 | 95 | 61 | 54 | 50 | 86 | 52 | 14 | 60 | 82 | 9 | 32 | 14 | 75 | 5 | 66 | 33 | 85 | 25
Item J | 16 | 20 | 29 | 45 | 53 | 7 | 52 | 56 | 57 | 91 | 14 | 67 | 78 | 11 | 53 | 15 | 34 | 73 | 93 | 40 | 49 | 14 | 16 | 6 | 77 | 61 | 39 | 65 | 90 | 18 | 99 | 85 | 57 | 12 | 66 | 14 | 72 | 64 | 30 | 9 | 99 | 65 | 91 | 79 | 66 | 25 | 86 | 51 | 22 | 40 | 68 | 23 | 26 | 72 | 6 | 5 | 92 | 97 | 96 | 25 | 64 | 30 | 49 | 27 | 86 | 87 | 33 | 79 | 18 | 65 | 95 | 23 | 41 | 64 | 16 | 16 | 42 | 89 | 86 | 50 | 33 | 79 | 66 | 11
[NAME] | 51 | 79 | 6 | 71 | 23 | 98 | 53 | 89 | 46 | 46 | 63 | 55 | 61 | 62 | 96 | 86 | 87 | 38 | 18 | 11 | 73 | 91 | 15 | 50 | 20 | 63 | 95 | 4 | 32 | 43 | 53 | 37 | 46 | 22 | 44 | 92 | 4 | 96 | 36 | 14 | 54 | 34 | 51 | 98 | 19 | 58 | 70 | 63 | 38 | 55 | 56 | 80 | 98 | 57 | 29 | 91 | 7 | 91 | 18 | 21 | 100 | 62 | 75 | 39 | 4 | 30 | 49 | 15 | 98 | 56 | 92 | 62 | 86 | 28 | 84 | 72 | 53 | 23 | 64 | 96 | 56 | 9 | 75 | 62
Item L | 47 | 75 | 90 | 38 | 68 | 31 | 98 | 43 | 86 | 92 | 34 | 99 | 16 | 64 | 16 | 32 | 99 | 5 | 17 | 50 | 40 | 44 | 93 | 39 | 28 | 17 | 44 | 84 | 22 | 100 | 46 | 23 | 32 | 79 | 44 | 2 | 17 | 41 | 94 | 32 | 57 | 25 | 79 | 45 | 28 | 64 | 89 | 1 | 76 | 41 | 74 | 20 | 54 | 23 | 5 | 19 | 37 | 61 | 93 | 64 | 2 | 84 | 67 | 44 | 51 | 7 | 41 | 15 | 93 | 59 | 52 | 86 | 9 | 26 | 79 | 44 | 11 | 20 | 50 | 1 | 95 | 19 | 67 | 100
Item M | 29 | 63 | 80 | 66 | 27 | 16 | 73 | 46 | 35 | 51 | 18 | 81 | 47 | 5 | 42 | 67 | 52 | 36 | 95 | 39 | 16 | 80 | 75 | 68 | 5 | 97 | 79 | 19 | 60 | 29 | 43 | 46 | 41 | 51 | 42 | 77 | 18 | 75 | 38 | 76 | 97 | 30 | 54 | 69 | 12 | 62 | 15 | 62 | 25 | 17 | 81 | 72 | 27 | 46 | 72 | 34 | 68 | 92 | 66 | 24 | 87 | 86 | 85 | 79 | 94 | 84 | 93 | 91 | 12 | 11 | 78 | 31 | 27 | 26 | 4 | 23 | 96 | 14 | 43 | 1 | 79 | 56 | 97 | 71
Item N | 21 | 48 | 20 | 38 | 7 | 52 | 23 | 6 | 10 | 86 | 31 | 50 | 71 | 38 | 100 | 67 | 78 | 18 | 54 | 86 | 19 | 20 | 48 | 78 | 13 | 23 | 77 | 62 | 44 | 25 | 33 | 8 | 15 | 19 | 4 | 44 | 47 | 14 | 21 | 87 | 22 | 22 | 97 | 9 | 96 | 81 | 11 | 8 | 44 | 96 | 88 | 51 | 63 | 3 | 49 | 17 | 98 | 13 | 21 | 66 | 12 | 4 | 75 | 92 | 22 | 45 | 68 | 13 | 35 | 10 | 74 | 74 | 45 | 3 | 59 | 15 | 90 | 62 | 44 | 64 | 27 | 65 | 1 | 85
Item O | 79 | 18 | 93 | 47 | 5 | 53 | 97 | 31 | 79 | 18 | 24 | 6 | 38 | 53 | 84 | 62 | 13 | 20 | 39 | 43 | 98 | 29 | 49 | 67 | 49 | 34 | 61 | 4 | 59 | 22 | 42 | 76 | 63 | 91 | 51 | 62 | 9 | 57 | 87 | 83 | 30 | 14 | 37 | 54 | 98 | 53 | 42 | 88 | 44 | 32 | 60 | 67 | 45 | 46 | 48 | 86 | 3 | 67 | 57 | 27 | 31 | 58 | 84 | 42 | 20 | 95 | 4 | 85 | 24 | 53 | 24 | 87 | 6 | 15 | 99 | 57 | 2 | 48 | 40 | 63 | 4 | 4 | 22 | 45
Item P | 81 | 58 | 74 | 33 | 46 | 52 | 37 | 73 | 88 | 7 | 34 | 32 | 29 | 22 | 45 | 56 | 7 | 73 | 51 | 71 | 21 | 67 | 11 | 5 | 81 | 68 | 82 | 21 | 53 | 26 | 95 | 50 | 86 | 40 | 32 | 81 | 93 | 62 | 71 | 2 | 41 | 4 | 53 | 46 | 15 | 43 | 46 | 91 | 20 | 2 | 87 | 6 | 99 | 24 | 38 | 78 | 75 | 95 | 46 | 76 | 53 | 8 | 63 | 51 | 29 | 8 | 57 | 100 | 14 | 35 | 33 | 10 | 68 | 5 | 23 | 94 | 96 | 70 | 86 | 5 | 54 | 85 | 57 | 62
Item Q | 54 | 100 | 75 | 96 | 26 | 11 | 66 | 100 | 13 | 44 | 51 | 78 | 70 | 37 | 20 | 56 | 36 | 7 | 55 | 12 | 27 | 35 | 16 | 25 | 77 | 5 | 8 | 78 | 36 | 49 | 10 | 27 | 46 | 32 | 51 | 23 | 48 | 2 | 67 | 93 | 86 | 61 | 44 | 30 | 75 | 11 | 53 | 79 | 54 | 19 | 57 | 45 | 2 | 63 | 71 | 16 | 4 | 37 | 86 | 69 | 23 | 14 | 30 | 77 | 90 | 49 | 53 | 51 | 66 | 94 | 93 | 2 | 89 | 91 | 55 | 68 | 46 | 66 | 89 | 3 | 44 | 4 | 63 | 52
Item R | 29 | 78 | 88 | 25 | 52 | 25 | 58 | 31 | 30 | 56 | 14 | 61 | 93 | 70 | 86 | 91 | 31 | 81 | 44 | 72 | 49 | 54 | 78 | 49 | 53 | 23 | 2 | 95 | 2 | 70 | 35 | 20 | 47 | 46 | 29 | 83 | 8 | 14 | 6 | 73 | 58 | 18 | 85 | 76 | 33 | 33 | 9 | 76 | 95 | 15 | 32 | 57 | 50 | 42 | 79 | 56 | 97 | 91 | 31 | 77 | 16 | 3 | 35 | 65 | 11 | 89 | 98 | 100 | 88 | 41 | 19 | 12 | 8 | 48 | 61 | 20 | 81 | 85 | 72 | 48 | 99 | 82 | 93 | 88
Item S | 39 | 72 | 93 | 40 | 78 | 38 | 40 | 6 | 85 | 27 | 9 | 82 | 61 | 51 | 50 | 22 | 86 | 53 | 74 | 13 | 73 | 53 | 1 | 43 | 73 | 44 | 46 | 23 | 75 | 45 | 61 | 84 | 46 | 16 | 98 | 93 | 37 | 54 | 60 | 60 | 39 | 35 | 37 | 44 | 3 | 2 | 58 | 23 | 59 | 82 | 40 | 68 | 87 | 5 | 42 | 30 | 71 | 70 | 14 | 82 | 17 | 23 | 79 | 7 | 21 | 95 | 55 | 36 | 38 | 17 | 71 | 79 | 7 | 79 | 58 | 45 | 15 | 96 | 33 | 30 | 79 | 40 | 25 | 6
Item T | 66 | 49 | 22 | 64 | 45 | 12 | 9 | 95 | 18 | 41 | 92 | 1 | 39 | 65 | 73 | 20 | 63 | 48 | 36 | 10 | 34 | 86 | 42 | 13 | 82 | 13 | 8 | 54 | 46 | 2 | 97 | 11 | 51 | 15 | 30 | 10 | 57 | 3 | 18 | 76 | 94 | 67 | 31 | 28 | 80 | 35 | 71 | 32 | 32 | 45 | 76 | 42 | 68 | 50 | 11 | 24 | 87 | 67 | 62 | 45 | 45 | 35 | 25 | 86 | 7 | 65 | 18 | 4 | 79 | 69 | 20 | 11 | 78 | 85 | 60 | 10 | 49 | 30 | 7 | 13 | 74 | 37 | 40 | 11