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

Year | Month | Account | Amount
2010 | January | 401000 | 312822.93
2010 | February | 401000 | 299104.61
2010 | March | 401000 | 277760.16
2010 | April | 401000 | 298015.02
2010 | May | 401000 | 325878.47
2010 | June | 401000 | 565099.55
2010 | July | 401000 | 480023.37
2010 | August | 401000 | 400434.52
2010 | September | 401000 | 378213.64
2010 | October | 401000 | 340682.53
2010 | November | 401000 | 563962
2010 | December | 401000 | 174394.98
2009 | January | 401000 | 257160.57
2009 | February | 401000 | 242440.08
2009 | March | 401000 | 226248.08
2009 | April | 401000 | 189304.99
2009 | May | 401000 | 284879.38
2009 | June | 401000 | 387189.52
2009 | July | 401000 | 385196.02
2009 | August | 401000 | 317597.16
2009 | September | 401000 | 239619.56
2009 | October | 401000 | 262989.56
2009 | November | 401000 | 260910.19
2009 | December | 401000 | 331857.34
2008 | January | 401000 | 275886.74
2008 | February | 401000 | 250519.68
2008 | March | 401000 | 250868.42
2008 | April | 401000 | 253594.98
2008 | May | 401000 | 299089.04
2008 | June | 401000 | 366485.92
2008 | July | 401000 | 362607.13
2008 | August | 401000 | 323078.35
2008 | September | 401000 | 237750.47
2008 | October | 401000 | 229809.6
2008 | November | 401000 | 253729.53
2008 | December | 401000 | 294501.86
2007 | January | 401000 | 172262.78
2007 | February | 401000 | 148126.64
2007 | March | 401000 | 194249.96
2007 | April | 401000 | 171343.76
2007 | May | 401000 | 193796.97
2007 | June | 401000 | 250494.84
2007 | July | 401000 | 280008.57
2007 | August | 401000 | 266448.51
2007 | September | 401000 | 183926.23
2007 | October | 401000 | 181828.47
2007 | November | 401000 | 242470.67
2007 | December | 401000 | 253183.53
2006 | January | 401000 | 243763.79
2006 | February | 401000 | 196941.46
2006 | March | 401000 | 263209.63
2006 | April | 401000 | 197767.48
2006 | May | 401000 | 234242.85
2006 | June | 401000 | 229652.77
2006 | July | 401000 | 251779.22
2006 | August | 401000 | 303976.53
2006 | September | 401000 | 189467.91
2006 | October | 401000 | 164244.91
2006 | November | 401000 | 167631.73
2006 | December | 401000 | 182156.39
2010 | January | 401200 | 0
2010 | February | 401200 | 0
2010 | March | 401200 | 0
2010 | April | 401200 | 0
2010 | May | 401200 | 0
2010 | June | 401200 | 0
2010 | July | 401200 | 0
2010 | August | 401200 | 0
2010 | September | 401200 | 0
2010 | October | 401200 | 289635
2010 | November | 401200 | 90005.03
2010 | December | 401200 | 222825.5
2009 | January | 401200 | 0
2009 | February | 401200 | 0
2009 | March | 401200 | 0
2009 | April | 401200 | 481872.99
2009 | May | 401200 | 315837.12
2009 | June | 401200 | 0
2009 | July | 401200 | 22.99
2009 | August | 401200 | 0
2009 | September | 401200 | 0
2009 | October | 401200 | 0
2009 | November | 401200 | 0
2009 | December | 401200 | 0
2008 | January | 401200 | 0
2008 | February | 401200 | 42.13
2008 | March | 401200 | 141.63
2008 | April | 401200 | 0
2008 | May | 401200 | 0
2008 | June | 401200 | 0
2008 | July | 401200 | 1002330.63
2008 | August | 401200 | 314.38
2008 | September | 401200 | 116
2008 | October | 401200 | 0
2008 | November | 401200 | 0
2008 | December | 401200 | 0
2007 | January | 401200 | 0
2007 | February | 401200 | 0
2007 | March | 401200 | 133.91
2007 | April | 401200 | 0
2007 | May | 401200 | 1395.93
2007 | June | 401200 | 0
2007 | July | 401200 | 0
2007 | August | 401200 | 510.04
2007 | September | 401200 | 0
2007 | October | 401200 | 0
2007 | November | 401200 | 0
2007 | December | 401200 | 1329.66
2006 | January | 401200 | 0
2006 | February | 401200 | 0
2006 | March | 401200 | 0
2006 | April | 401200 | 0
2006 | May | 401200 | 0
2006 | June | 401200 | 0
2006 | July | 401200 | 0
2006 | August | 401200 | 0
2006 | September | 401200 | 0
2006 | October | 401200 | 0
2006 | November | 401200 | 0
2006 | December | 401200 | 197.86
2010 | January | 401400 | 18.12
2010 | February | 401400 | 767.64
2010 | March | 401400 | 282.99
2010 | April | 401400 | 659.24
2010 | May | 401400 | 77.92
2010 | June | 401400 | 2450.75
2010 | July | 401400 | 1534.66
2010 | August | 401400 | 58.23
2010 | September | 401400 | 96.77
2010 | October | 401400 | 479.73
2010 | November | 401400 | 227.71
2010 | December | 401400 | 535.03
2009 | January | 401400 | 0
2009 | February | 401400 | 3800.91
2009 | March | 401400 | 0
2009 | April | 401400 | 504.42
2009 | May | 401400 | 274.95
2009 | June | 401400 | 52655.84
2009 | July | 401400 | 725.98
2009 | August | 401400 | 259.52
2009 | September | 401400 | 145.24
2009 | October | 401400 | 203.84
2009 | November | 401400 | 571.26
2009 | December | 401400 | 474.31
2008 | January | 401400 | -352.33
2008 | February | 401400 | 610.23
2008 | March | 401400 | 0
2008 | April | 401400 | 232.55
2008 | May | 401400 | 32.25
2008 | June | 401400 | 1311.65
2008 | July | 401400 | 892.66
2008 | August | 401400 | 91.99
2008 | September | 401400 | 16.82
2008 | October | 401400 | 695.95
2008 | November | 401400 | 544.33
2008 | December | 401400 | 958.89
2007 | January | 401400 | 266.54
2007 | February | 401400 | 560.02
2007 | March | 401400 | 3223.71
2007 | April | 401400 | 691.61
2007 | May | 401400 | 1697.24
2007 | June | 401400 | 547.37
2007 | July | 401400 | 0
2007 | August | 401400 | 27.84
2007 | September | 401400 | 0
2007 | October | 401400 | 115.39
2007 | November | 401400 | 0
2007 | December | 401400 | 700.65
2006 | January | 401400 | 2980.95
2006 | February | 401400 | 184.2
2006 | March | 401400 | 243.88
2006 | April | 401400 | 74.96
2006 | May | 401400 | 339.96
2006 | June | 401400 | 83.27
2006 | July | 401400 | 0
2006 | August | 401400 | 73.26
2006 | September | 401400 | 1444.5
2006 | October | 401400 | 350.39
2006 | November | 401400 | 46821.71
2006 | December | 401400 | 180.46
2010 | January | 401750 | 2641.18
2010 | February | 401750 | 5919.32
2010 | March | 401750 | 288.22
2010 | April | 401750 | 10869.72
2010 | May | 401750 | 0
2010 | June | 401750 | 5191.76
2010 | July | 401750 | 5554.19
2010 | August | 401750 | 4756.7
2010 | September | 401750 | 4988.55
2010 | October | 401750 | 3734.96
2010 | November | 401750 | 5506.01
2010 | December | 401750 | 6535.38
2009 | January | 401750 | 3601.22
2009 | February | 401750 | 3432.08
2009 | March | 401750 | -123.84
2009 | April | 401750 | 5736.03
2009 | May | 401750 | 4043.91
2009 | June | 401750 | -286.86
2009 | July | 401750 | 2801.89
2009 | August | 401750 | 4351.75
2009 | September | 401750 | 4044.04
2009 | October | 401750 | 3197.41
2009 | November | 401750 | 1714.71
2009 | December | 401750 | 3859.3
2008 | January | 401750 | 2472.68
2008 | February | 401750 | 2312.83
2008 | March | 401750 | 5613.56
2008 | April | 401750 | 6.11
2008 | May | 401750 | 3402.12
2008 | June | 401750 | 6.76
2008 | July | 401750 | 3956.91
2008 | August | 401750 | 3307.68
2008 | September | 401750 | 2860.37
2008 | October | 401750 | 3325.56
2008 | November | 401750 | 3622.61
2008 | December | 401750 | 5813.78
2007 | January | 401750 | 0
2007 | February | 401750 | 212.47
2007 | March | 401750 | 381.24
2007 | April | 401750 | 0
2007 | May | 401750 | 0
2007 | June | 401750 | 0
2007 | July | 401750 | 382.71
2007 | August | 401750 | 0
2007 | September | 401750 | 209.29
2007 | October | 401750 | 629.44
2007 | November | 401750 | 2051.54
2007 | December | 401750 | 156.97
2006 | January | 401750 | 0
2006 | February | 401750 | 290.6
2006 | March | 401750 | 172.42
2006 | April | 401750 | 0
2006 | May | 401750 | 90.08
2006 | June | 401750 | 0
2006 | July | 401750 | 308.69
2006 | August | 401750 | 725.47
2006 | September | 401750 | 80.74
2006 | October | 401750 | 0
2006 | November | 401750 | 518.17
2006 | December | 401750 | 0