Spreadsheet: 70018d1270668994-excel-2007-transposing-data-with-mirror-flip-copypastemirrorimage
Sheet: Sheet1

BEFORE
2009-01-03 00:00:00 | 2009-01-10 00:00:00 | 2009-01-17 00:00:00 | 2009-01-24 00:00:00 | 2009-01-31 00:00:00 | 2009-02-07 00:00:00 | 2009-02-14 00:00:00 | 2009-02-21 00:00:00 | 2009-02-28 00:00:00 | 2009-03-07 00:00:00 | 2009-03-14 00:00:00 | 2009-03-21 00:00:00
61.3918280780781 | 59.3099213120971 | 66.4736209876543 | 25.5281388888889 | 37.8327578176979 | 35.9406921296296 | 40.0415326510721 | 34.5406924019608 | 33.5349583333333 | 29.2033901515152 | 10.7395238095238 | 11.3492669753086
119.171414141414 | 118.795808080808 | 71.7679761904762 | 17.8586111111111 | 77.903134920635 | 113.930138888889 | 13.1857777777778 | 16.51 | 55.473125 | 85.3828333333334 | 12.2566132478633 | 11.3047643097643
44.7973792270531 | 53.394023297491 | 35.2740443425076 | 42.6953240740741 | 33.8281034482759 | 34.6455141843972 | 40.2849631519274 | 32.2135706018518 | 18.8919405320814 | 26.2468055555556 | 5.69805555555556 | 8.65129629629629
48.8213319088319 | 41.3424439102564 | 24.7479817158931 | 25.0955815972222 | 28.4155283816425 | 35.9286497890295 | 27.8161168981482 | 40.3425224466891 | 29.1120625 | 22.8050434027778 | 12.6482291666667 | 14.5695881226054
56.7898777777778 | 69.8076967592593 | 33.0750173611111 | 36.2684343434343 | 41.6657679738562 | 21.1465151515151 | 53.0353395061729 | 61.0741666666667 | 10.0056565656566 | 2.85555555555556 | 9.54740740740741 | 6.67333333333334
34.0203794037941 | 32.6703737373737 | 30.9820687134503 | 15.5939409722222 | 12.7677032520325 | 16.3926876876877 | 42.348839031339 | 24.0147552910053 | 20.8796212121212 | 25.4518703703704 | 10.368487654321 | 7.48189542483661
35.3153262626263 | 40.9842514124294 | 32.0237233054782 | 22.5636694847021 | 24.7836511437909 | 31.7148189484127 | 28.0028725684141 | 21.6366446842526 | 12.5557660902978 | 26.3228107344633 | 9.35946153846154 | 9.61386284722222
54.1418506006006 | 43.3383719135802 | 27.1557530864198 | 41.4065708812261 | 41.4369533096927 | 27.9838152896486 | 32.9169072164948 | 30.9129513888889 | 32.0634748427673 | 18.0371448087432 | 6.058125 | 8.92460185185185
30.1090229885057 | 49.8326955409357 | 42.4547695951766 | 22.356887755102 | 24.3789393939394 | 33.9692922008547 | 36.820091503268 | 26.6736699346405 | 20.1200412912913 | 35.4621246246246 | 10.9693393393393 | 8.5539605734767
60.2966907514451 | 56.0513385225885 | 51.7162540610786 | 39.8582692307692 | 48.7729135802469 | 38.8434712509713 | 46.9503120243531 | 35.101000761035 | 32.3294353864734 | 32.6400648148148 | 9.92319716775599 | 10.8715322580645
34.7908939835032 | 37.1994472361809 | 25.9964525580347 | 19.6206352880658 | 24.4928401997503 | 26.5874570386064 | 32.1723422060899 | 23.102979260692 | 24.9396364773133 | 26.1681450617284 | 9.10915522875817 | 8.40014601139601
37.6797401433692 | 64.5296451914099 | 32.0776331496786 | 40.2069389978213 | 37.5162665647299 | 31.6616805555556 | 34.0626127612761 | 32.9843086419753 | 31.7746937321937 | 36.6634513888889 | 15.9728639846743 | 12.6785813492063
41.8318167562724 | 39.3713373253493 | 31.9136111111111 | 33.3696122685185 | 26.1165456545655 | 30.4306133333333 | 31.8433624551971 | 28.8630456349206 | 11.3314987562189 | 27.8254365079365 | 9.51170454545454 | 7.88249287749288
26.365243498818 | 71.4900087719298 | 41.2312534722222 | 48.6480612244898 | 35.2283687943262 | 32.9636895794099 | 56.9630917159763 | 37.2836603624901 | 38.6055495169082 | 30.1121188630491 | 10.2222718253968 | 7.50314236111111
35.4118650793651 | 42.613653779171 | 36.3284688552188 | 32.2463266666667 | 33.3712195340502 | 25.9727104982681 | 41.7026578674948 | 26.3609659565581 | 13.6733898868929 | 28.5078020496224 | 12.3503868120457 | 10.1516666666667
41.4 | 47.7 | 36.9 | 33.4 | 31 | 30.3 | 36.8 | 28.7 | 20.9 | 27.8863818438003 | 10.3345054200542 | 9.60963901689708
AFTER
2009-03-21 00:00:00 | 2009-03-14 00:00:00 | 2009-03-07 00:00:00 | 2009-02-28 00:00:00 | 2009-02-21 00:00:00 | 2009-02-14 00:00:00 | 2009-02-07 00:00:00 | 2009-01-31 00:00:00 | 2009-01-24 00:00:00 | 2009-01-17 00:00:00 | 2009-01-10 00:00:00 | 2009-01-03 00:00:00
11.3492669753086 | 10.7395238095238 | 29.2033901515152 | 33.5349583333333 | 34.5406924019608 | 40.0415326510721 | 35.9406921296296 | 37.8327578176979 | 25.5281388888889 | 66.4736209876543 | 59.3099213120971 | 61.3918280780781
11.3047643097643 | 12.2566132478633 | 85.3828333333334 | 55.473125 | 16.51 | 13.1857777777778 | 113.930138888889 | 77.903134920635 | 17.8586111111111 | 71.7679761904762 | 118.795808080808 | 119.171414141414
8.65129629629629 | 5.69805555555556 | 26.2468055555556 | 18.8919405320814 | 32.2135706018518 | 40.2849631519274 | 34.6455141843972 | 33.8281034482759 | 42.6953240740741 | 35.2740443425076 | 53.394023297491 | 44.7973792270531
14.5695881226054 | 12.6482291666667 | 22.8050434027778 | 29.1120625 | 40.3425224466891 | 27.8161168981482 | 35.9286497890295 | 28.4155283816425 | 25.0955815972222 | 24.7479817158931 | 41.3424439102564 | 48.8213319088319
6.67333333333334 | 9.54740740740741 | 2.85555555555556 | 10.0056565656566 | 61.0741666666667 | 53.0353395061729 | 21.1465151515151 | 41.6657679738562 | 36.2684343434343 | 33.0750173611111 | 69.8076967592593 | 56.7898777777778
7.48189542483661 | 10.368487654321 | 25.4518703703704 | 20.8796212121212 | 24.0147552910053 | 42.348839031339 | 16.3926876876877 | 12.7677032520325 | 15.5939409722222 | 30.9820687134503 | 32.6703737373737 | 34.0203794037941
9.61386284722222 | 9.35946153846154 | 26.3228107344633 | 12.5557660902978 | 21.6366446842526 | 28.0028725684141 | 31.7148189484127 | 24.7836511437909 | 22.5636694847021 | 32.0237233054782 | 40.9842514124294 | 35.3153262626263
8.92460185185185 | 6.058125 | 18.0371448087432 | 32.0634748427673 | 30.9129513888889 | 32.9169072164948 | 27.9838152896486 | 41.4369533096927 | 41.4065708812261 | 27.1557530864198 | 43.3383719135802 | 54.1418506006006
8.5539605734767 | 10.9693393393393 | 35.4621246246246 | 20.1200412912913 | 26.6736699346405 | 36.820091503268 | 33.9692922008547 | 24.3789393939394 | 22.356887755102 | 42.4547695951766 | 49.8326955409357 | 30.1090229885057
10.8715322580645 | 9.92319716775599 | 32.6400648148148 | 32.3294353864734 | 35.101000761035 | 46.9503120243531 | 38.8434712509713 | 48.7729135802469 | 39.8582692307692 | 51.7162540610786 | 56.0513385225885 | 60.2966907514451
8.40014601139601 | 9.10915522875817 | 26.1681450617284 | 24.9396364773133 | 23.102979260692 | 32.1723422060899 | 26.5874570386064 | 24.4928401997503 | 19.6206352880658 | 25.9964525580347 | 37.1994472361809 | 34.7908939835032
12.6785813492063 | 15.9728639846743 | 36.6634513888889 | 31.7746937321937 | 32.9843086419753 | 34.0626127612761 | 31.6616805555556 | 37.5162665647299 | 40.2069389978213 | 32.0776331496786 | 64.5296451914099 | 37.6797401433692
7.88249287749288 | 9.51170454545454 | 27.8254365079365 | 11.3314987562189 | 28.8630456349206 | 31.8433624551971 | 30.4306133333333 | 26.1165456545655 | 33.3696122685185 | 31.9136111111111 | 39.3713373253493 | 41.8318167562724
7.50314236111111 | 10.2222718253968 | 30.1121188630491 | 38.6055495169082 | 37.2836603624901 | 56.9630917159763 | 32.9636895794099 | 35.2283687943262 | 48.6480612244898 | 41.2312534722222 | 71.4900087719298 | 26.365243498818
10.1516666666667 | 12.3503868120457 | 28.5078020496224 | 13.6733898868929 | 26.3609659565581 | 41.7026578674948 | 25.9727104982681 | 33.3712195340502 | 32.2463266666667 | 36.3284688552188 | 42.613653779171 | 35.4118650793651
9.60963901689708 | 10.3345054200542 | 27.8863818438003 | 20.9 | 28.7 | 36.8 | 30.3 | 31 | 33.4 | 36.9 | 47.7 | 41.4