example  of what I need
to be able to do:

Source Data on Sheet2:

SF Year
732 MTM
446 MTM
1,827 MTM
353 MTM
1,060 MTM
373 MTM
728 MTM
286 MTM
254 MTM
271 MTM
271 MTM
550 MTM
286 MTM
430 2006
732 2006
4,141 2006
210 2006
526 2006
1,469 2007
4,524 2007
991 2007
880 2007
1,596 2007
2,548 2007
1,500 2007
776 2007
3,958 2007
3,486 2007
1,040 2007
3,989 2007
758 2007
3,868 2007
480 2008
0 2008
468 2008
6,737 2008
7,800 2009
2,912 2010
4,889 2010
916 2010
3,530 2010

The code  I need would result  in the following on Sheet1:

MTM 2006 2007 2008 2009 2010
732
446
1,827
353
1,060
373
728
286
254
271
271
550
286
430
732
4,141
210
526
1,469
4,524
991
880
1,596
2,548
1,500
776
3,958
3,486
1,040
3,989
758
3,868
480
0
468
6,737
7,800
2,912
4,889
916
3,530
Any help would be greatly appreciated!