Spreadsheet: 118746d1313975395-macro-to-transpose-multiple-rows-to-one-colums-example
Sheet: Original

Year | Account | January | February | March | April | May | June | July | August | September | October | November | December
2010 | 401000 | 312822.93 | 299104.61 | 277760.16 | 298015.02 | 325878.47 | 565099.55 | 480023.37 | 400434.52 | 378213.64 | 340682.53 | 563962 | 174394.98
2009 | 401000 | 257160.57 | 242440.08 | 226248.08 | 189304.99 | 284879.38 | 387189.52 | 385196.02 | 317597.16 | 239619.56 | 262989.56 | 260910.19 | 331857.34
2008 | 401000 | 275886.74 | 250519.68 | 250868.42 | 253594.98 | 299089.04 | 366485.92 | 362607.13 | 323078.35 | 237750.47 | 229809.6 | 253729.53 | 294501.86
2007 | 401000 | 172262.78 | 148126.64 | 194249.96 | 171343.76 | 193796.97 | 250494.84 | 280008.57 | 266448.51 | 183926.23 | 181828.47 | 242470.67 | 253183.53
2006 | 401000 | 243763.79 | 196941.46 | 263209.63 | 197767.48 | 234242.85 | 229652.77 | 251779.22 | 303976.53 | 189467.91 | 164244.91 | 167631.73 | 182156.39
2010 | 401200 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 289635 | 90005.03 | 222825.5
2009 | 401200 | 0 | 0 | 0 | 481872.99 | 315837.12 | 0 | 22.99 | 0 | 0 | 0 | 0 | 0
2008 | 401200 | 0 | 42.13 | 141.63 | 0 | 0 | 0 | 1002330.63 | 314.38 | 116 | 0 | 0 | 0
2007 | 401200 | 0 | 0 | 133.91 | 0 | 1395.93 | 0 | 0 | 510.04 | 0 | 0 | 0 | 1329.66
2006 | 401200 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 197.86
2010 | 401400 | 18.12 | 767.64 | 282.99 | 659.24 | 77.92 | 2450.75 | 1534.66 | 58.23 | 96.77 | 479.73 | 227.71 | 535.03
2009 | 401400 | 0 | 3800.91 | 0 | 504.42 | 274.95 | 52655.84 | 725.98 | 259.52 | 145.24 | 203.84 | 571.26 | 474.31
2008 | 401400 | -352.33 | 610.23 | 0 | 232.55 | 32.25 | 1311.65 | 892.66 | 91.99 | 16.82 | 695.95 | 544.33 | 958.89
2007 | 401400 | 266.54 | 560.02 | 3223.71 | 691.61 | 1697.24 | 547.37 | 0 | 27.84 | 0 | 115.39 | 0 | 700.65
2006 | 401400 | 2980.95 | 184.2 | 243.88 | 74.96 | 339.96 | 83.27 | 0 | 73.26 | 1444.5 | 350.39 | 46821.71 | 180.46
2010 | 401750 | 2641.18 | 5919.32 | 288.22 | 10869.72 | 0 | 5191.76 | 5554.19 | 4756.7 | 4988.55 | 3734.96 | 5506.01 | 6535.38
2009 | 401750 | 3601.22 | 3432.08 | -123.84 | 5736.03 | 4043.91 | -286.86 | 2801.89 | 4351.75 | 4044.04 | 3197.41 | 1714.71 | 3859.3
2008 | 401750 | 2472.68 | 2312.83 | 5613.56 | 6.11 | 3402.12 | 6.76 | 3956.91 | 3307.68 | 2860.37 | 3325.56 | 3622.61 | 5813.78
2007 | 401750 | 0 | 212.47 | 381.24 | 0 | 0 | 0 | 382.71 | 0 | 209.29 | 629.44 | 2051.54 | 156.97
2006 | 401750 | 0 | 290.6 | 172.42 | 0 | 90.08 | 0 | 308.69 | 725.47 | 80.74 | 0 | 518.17 | 0
2009 | 402000 | 588.79 | 519.44 | 724.63 | 54.94 | 1610.3 | 2942.43 | 2169.14 | 3392.86 | 1287.01 | 2683.75 | 684.88 | 3615.95
2008 | 402000 | 1729.66 | 1697.28 | 1241.6 | 1427.1 | 501.75 | 2228.68 | 9985.49 | 1185.84 | 2149.07 | 1614.52 | 2792.69 | 1803.27
2007 | 402000 | 848.02 | 1629.04 | 2724.44 | 1648.03 | 1131.75 | 1931.36 | 1271.61 | 2676.49 | 1142.96 | 965.5 | 1590.76 | 2526.63
2006 | 402000 | 1748.7 | 1007.45 | 1314.77 | 1380.6 | 3350.86 | 518.81 | 2275.82 | 2033.43 | 1875.65 | 1386.02 | 3229.51 | 270.22
2010 | 403000 | 4788373.37 | 4561935.81 | 5283013 | 5168334.74 | 4872824.64 | 5179904.3 | 5252481.32 | 5204293.1 | 5253038.47 | 4936164.72 | 5281711.84 | 5512455.91
2009 | 403000 | 4475165.1 | 4366976.49 | 4556773.66 | 4638149.01 | 4320637.15 | 4693709.23 | 5003097.78 | 4601056.87 | 4875984.07 | 4936540.71 | 4539329.9 | 5098206.94
2008 | 403000 | 4413154.71 | 4415805.99 | 4263686.45 | 4374368.22 | 3915929.11 | 3666650.7 | 4748306.94 | 4208523.32 | 4476512.24 | 4628472.61 | 4113919.52 | 4786283.76
2007 | 403000 | 3873919.34 | 3661042.28 | 3781207.1 | 3650751.06 | 4012416.14 | 3670127.42 | 3853714.56 | 4060308.57 | 3569485.24 | 4181684.51 | 4059839.68 | 3903536.81
2006 | 403000 | 3290364.43 | 3206667.14 | 3425841.12 | 3012109.03 | 3597384.78 | 3427724.11 | 3218875.2 | 3650813.2 | 3339820.76 | 3529677.22 | 3572849.21 | 3414678.92
2010 | 403400 | 68659.04 | 74046.22 | 6822.31 | 5591.44 | 2812.28 | 22699.98 | 18711.74 | 7591.32 | 19923.33 | 7228.87 | 41585.21 | 20331.7
2009 | 403400 | 1484.23 | 117091.16 | 8530.45 | 3712.63 | 3621.21 | 736509.31 | 13548.64 | 4790.24 | -68310.95 | 9649.33 | 29661.31 | 9823.84
2008 | 403400 | 5745.05 | 51525.24 | 51492.22 | 6496.86 | 1972.48 | 10612.59 | 6178.92 | 9381.17 | 3968.47 | 9872.4 | 8007.2 | 88598
2007 | 403400 | 18522.2 | 18009.89 | 9195.18 | 8004.07 | 16154.87 | 12974.08 | 12413.14 | 5176.54 | 2942.31 | 7871.7 | 3834.74 | 40098.55
2006 | 403400 | 19853.34 | -296.93 | 13725.52 | 916.72 | 6298.08 | 4349.96 | 30650.82 | 6203.12 | 7180.74 | 4766.96 | 645767.33 | 20320.41
2010 | 403750 | 25471.23 | 30757.74 | 0 | 35017.62 | 25812.6 | 4136.32 | 21274.3 | 24558.53 | 22531.41 | 17627.95 | 20421.41 | 17796.51
2009 | 403750 | 24507.89 | 32197.91 | 287.8 | 34496.69 | 27812.07 | 0 | 33647.22 | 37578.2 | 33035.37 | 35928.92 | 34653.17 | 39505.39
2008 | 403750 | 5102.27 | 12632.48 | 28650.93 | 113.36 | 18231.82 | 1360.33 | 32993.41 | 23195.15 | 25327.17 | 25966.26 | 29533.87 | 43126.11
2007 | 403750 | 791.65 | 850.91 | 200.36 | 0 | 0 | 695.02 | 561.33 | 503.68 | 0 | 3698.04 | 2549.81 | 7637.7
2006 | 403750 | 0 | 494.09 | 658.52 | 0 | 0 | 0 | 985.4 | 79.08 | 0 | 0 | 211.61 | 1586.58
2010 | 408000 | 32250.11 | 67421.98 | 137640.7 | 82391.77 | 103882.25 | 65626.43 | 87204.43 | 177023.09 | 131051.24 | 93701.13 | 126106.98 | 71546.08
2009 | 408000 | 0 | 83820.89 | 146220.92 | 195164.81 | 112377.45 | 107762.24 | 138586.7 | 155212.64 | 127980.83 | 126451.36 | 107658.07 | 125058.86
2008 | 408000 | 13162.63 | 49363.61 | 57584.34 | 72783.17 | 34601.3 | 24419.96 | 14184 | 160830.77 | 117042.07 | 91145.33 | 158976.85 | 271641.02
2007 | 408000 | 59398.77 | 86193.44 | 86038.55 | 94919.83 | 105087.69 | 77883.52 | 73800.73 | 77100.06 | 115807.84 | 61151.43 | 32640.41 | 31995.3
2006 | 408000 | 29696.38 | 26239.05 | 35261.64 | 27926.5 | 46850.97 | 46465.93 | 75619.53 | 145406.11 | 80132.17 | 64523.84 | 107955.01 | 116906.28
2010 | 608100 | -188477.3 | -189310.59 | -139214.3 | -238730.12 | -252860.6 | -246475.6 | -366268.08 | -330603.56 | -251334.6 | -206297.72 | -236240.24 | -153244.13
2009 | 608100 | -203118.89 | -177603.52 | -231033.23 | -239426.57 | -245381.06 | -245133.56 | -316009.66 | -373526.12 | -240015.89 | -225884.81 | -188089.29 | -276341.45
2008 | 608100 | -142793.86 | -167661.69 | -185499.86 | -198928.14 | -214582.54 | -217607.38 | -204009.64 | -443090.46 | -236739.9 | -249589.44 | -261976.97 | -284133.91
2007 | 608100 | -121463.72 | -165944.34 | -183968.96 | -154157.17 | -197763.89 | -203632.57 | -222130.23 | -232668.03 | -284691.34 | -156277.88 | -151221.67 | -178238.6
2006 | 608100 | -135299.44 | -142709.75 | -135670.81 | -153580.7 | -170728.41 | -171135.46 | -204775.09 | -143879.19 | -275911.31 | -117435.65 | -167122.33 | -278800.57
2010 | 407000 | 699.9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 0
2009 | 407000 | 0 | 0 | 0 | 3300 | 0 | 0 | 0 | 0 | 2670 | 0 | 0 | 0
2008 | 407000 | 0 | 0 | 0 | 0 | 0 | 0 | 5002 | 0 | 0 | 0 | 0 | 2870
2007 | 407000 | 0 | 0 | 0 | 0 | 0 | 0 | -2500 | 0 | -250 | 0 | 0 | 0
2010 | 407100 | 7261.44 | 6071.12 | 4016.88 | 7724 | 17045.93 | 8141.95 | 6574.98 | 5504.69 | 3533.81 | 5704.74 | 4313.19 | 3665.11
2009 | 407100 | 3200.63 | -2652.23 | 6827.05 | 6980.45 | 16369.03 | 8309.1 | 3821.02 | 707.08 | 1103.62 | 4106.88 | 2047.61 | 4170.01
2008 | 407100 | 721.36 | 56.4 | 0 | 0 | 2631.76 | 15659.22 | 2362.1 | 5097.27 | 5039.22 | 3071 | 6080.68 | 2168.69
2007 | 407100 | 638.68 | 0 | 0 | 0 | 47.03 | 0 | 0 | 0 | 43 | 0 | 0 | 0
2006 | 407100 | 370.42 | 250.8 | 43 | 0 | 70.79 | 0 | 0 | 0 | 0 | 0 | 47.02 | 0
2010 | 408600 | 0 | 77.25 | 0 | 0 | 0 | 0 | 17.67 | 0 | 393.27 | -28.09 | 105 | 42849.75
2009 | 408600 | 0 | 0 | 25 | 20 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0
2008 | 408600 | 0 | 0 | -2640 | 0 | 0 | 75 | 0 | 0 | 0 | 80 | 0 | 0
2007 | 408600 | 0 | 141.32 | 0 | 0 | 187.86 | -187.86 | -141.32 | 10340 | 0 | 0 | 8274.97 | 1696.6
2006 | 408600 | 0 | 0 | 0 | 0 | 0 | 35 | 0 | 409.06 | 216 | 242.14 | 0 | 843.41
2010 | 409100 | 304.5 | 304.5 | 0 | 304.5 | 304.5 | 315 | 0 | 315 | 315 | 315 | 315 | 315
2009 | 409100 | 304.5 | 304.5 | 304.5 | 304.5 | 304.5 | 304.5 | 304.5 | 304.5 | 304.5 | 304.5 | 304.5 | 304.5
2008 | 409100 | 797.64 | 816.34 | 1093.26 | 537.12 | -1952.86 | 262.5 | 816.34 | 1093.26 | 816.34 | 858.34 | 858.34 | 581.42
2007 | 409100 | 755.24 | 755.24 | 830.76 | 956.64 | 755.24 | 755.24 | 755.24 | 755.24 | 830.76 | 956.64 | 755.24 | 797.64
2006 | 409100 | 725.04 | 725.04 | 746.44 | 1023.36 | 746.44 | 746.44 | 744.64 | 744.64 | 1021.56 | 744.64 | 744.64 | 744.64
2010 | 409150 | 2891.14 | 3296.96 | 3769.87 | 2647.27 | 3030.39 | 6739.34 | 3178.44 | 2137.83 | 3811.47 | 4006.18 | 4131.03 | 5479.82
2009 | 409150 | 3259.7 | 5365.29 | 4042.06 | 3980.47 | 3199.46 | 6295.96 | 2801.37 | 2464.37 | 1994.53 | 4303.13 | 3144.4 | 7264.95
2008 | 409150 | 1047.94 | 6459.11 | 4085.49 | 3493.03 | 3636.11 | 4986.58 | 4268.77 | 2789.56 | 3395.66 | 4055.04 | 3757.23 | 6949.39
2007 | 409150 | 5708.4 | 1930.68 | 7283.06 | 4371.77 | 4618.24 | 5602.61 | 5930.99 | 5704.82 | 4208.6 | 3561.35 | 4698.1 | 7253.12
2006 | 409150 | 3045.85 | 3760.08 | 3500.12 | 5681.57 | 3959.48 | 6181.42 | 5297.54 | 2834.05 | 5142.43 | 3385.25 | 4918.6 | 6473.97
2010 | 409200 | 345.46 | 567.63 | 1032.66 | 2131.44 | 1466.07 | 1681.74 | 1416.55 | 842.99 | 598.57 | 2377.15 | 3860.62 | 2934.12
2009 | 409200 | 846.89 | 895.91 | 761.49 | 2461.8 | 1475.47 | 2304.37 | 23.09 | 1391.95 | 360.43 | 472.58 | 1545.47 | 2688.17
2008 | 409200 | 510.74 | 737.04 | 498.73 | 1219.74 | 436.13 | 500.09 | 1116.48 | 565.41 | 1079.41 | 755.88 | 1775.78 | 1610.81
2007 | 409200 | 476.37 | 148.75 | 511.92 | 257.11 | 599.55 | 361.51 | 654.11 | 504.25 | 462.07 | 555.2 | 885.34 | 1782.24
2006 | 409200 | 740.22 | 905.85 | -1150.11 | 699.04 | 449.08 | 783.22 | 395.38 | 624.87 | 785.35 | 300.75 | 714.1 | 910.33
2010 | 409500 | 141.42 | 1348.57 | 155.24 | 942.4 | 529.92 | 431.98 | 994.83 | 483.05 | 509.98 | 81.5 | 1783.98 | 853.19
2009 | 409500 | 126.66 | 509.2 | 1334.39 | 141.42 | 762.76 | 1568.19 | 805.91 | 844.39 | 450.66 | 681.06 | 572.87 | 611.75
2008 | 409500 | 112.38 | 705.16 | 126.66 | 1238.53 | 189.99 | 656.76 | 783.52 | 551.64 | 360.56 | 432.57 | 712.24 | 1154.28
2007 | 409500 | 465.47 | -137.34 | 437.74 | 984.92 | 281.78 | 216.31 | 523.92 | 448.96 | 9.43 | 914.41 | 111.32 | 2115.14
2006 | 409500 | 752.99 | 237.29 | 0 | 784.63 | 276.2 | 338.88 | 858.4 | 549.1 | 935.38 | 1132.83 | 400.19 | 850.52