| 791643 | -4,105.80 | -4,105.80 |
| 2/28/2006 | -240 | -240 |
| 12/31/2006 | -577.8 | -577.8 |
| 2/28/2007 | -256.8 | -256.8 |
| 3/31/2007 | -271.2 | -271.2 |
| 4/30/2007 | -345 | -345 |
| 5/31/2007 | -276 | -276 |
| 6/30/2007 | -276 | -276 |
| 7/31/2007 | -621 | -621 |
| 8/31/2007 | -345 | -345 |
| 10/31/2007 | -276 | -276 |
| 11/30/2007 | -276 | -276 |
| 12/31/2007 | -345 | -345 |
| 791647 | -13,800.00 | -13,800.00 |
| 2/28/2006 | -900 | -900 |
| 12/31/2006 | -900 | -900 |
| 1/31/2007 | -900 | -900 |
| 2/28/2007 | -900 | -900 |
| 3/31/2007 | -900 | -900 |
| 4/30/2007 | -900 | -900 |
| 5/31/2007 | -644.49 | -644.49 |
| 6/30/2007 | -1,155.51 | -1,155.51 |
| 7/31/2007 | -900 | -900 |
| 8/31/2007 | -900 | -900 |
| 9/30/2007 | -1,200.00 | -1,200.00 |
| 10/31/2007 | -1,200.00 | -1,200.00 |
| 11/30/2007 | -1,200.00 | -1,200.00 |
| 12/31/2007 | -1,200.00 | -1,200.00 |
| 791648 | -7,053.33 | -7,053.33 |
| 2/28/2006 | -352 | -352 |
| 12/31/2006 | -450.24 | -450.24 |
| 1/31/2007 | -438.12 | -438.12 |
| 2/28/2007 | -563.3 | -563.3 |
| 4/30/2007 | -477.24 | -477.24 |
| 5/31/2007 | -477.24 | -477.24 |
| 6/30/2007 | -1,073.79 | -1,073.79 |
| 8/31/2007 | -1,073.79 | -1,073.79 |
| 9/30/2007 | -477.24 | -477.24 |
| 10/31/2007 | -477.24 | -477.24 |
| 11/30/2007 | -596.55 | -596.55 |
| 12/31/2007 | -596.58 | -596.58 |
| 791654 | -2,056.22 | -2,056.23 |
| 3/15/2007 | -2,056.22 | -2,056.23 |
| 791655 | ||
| 12/31/2006 | ||
| 1/31/2007 | ||
| 2/28/2007 | ||
| 3/31/2007 | ||
| 4/30/2007 | ||
| 5/31/2007 | ||
| 6/30/2007 | ||
| 7/31/2007 | ||
| 8/31/2007 | ||
| 9/30/2007 | ||
| 10/31/2007 | ||
| 11/30/2007 | ||
| 12/31/2007 | ||
| 791657 | -3,660.00 | -3,660.00 |
| 1/31/2007 | -300 | -300 |
| 2/28/2007 | -240 | -240 |
| 3/31/2007 | -240 | -240 |
| 4/30/2007 | -360 | -360 |
| 5/31/2007 | -288 | -288 |
| 6/30/2007 | -288 | -288 |
| 7/31/2007 | -360 | -360 |
| 8/31/2007 | -288 | -288 |
| 9/30/2007 | -360 | -360 |
| 11/30/2007 | -576 | -576 |
| 12/31/2007 | -360 | -360 |
<tbody>
</tbody>
Please help me transpose the data above to rows, i am really stuck. after the Macro, i am expecting this result:
| Ref Number | 2/28/2006 | 12/31/2006 | 1/31/2007 | 2/28/2007 | 3/31/2007 | 4/30/2007 | 5/31/2007 | 6/30/2007 | 7/31/2007 | 8/31/2007 | 9/30/2007 | 10/31/2007 | 11/30/2007 | 12/31/2007 | 2/28/2006 | 12/31/2006 | 1/31/2007 | 2/28/2007 | 3/31/2007 | 4/30/2007 | 5/31/2007 | 6/30/2007 | 7/31/2007 | 8/31/2007 | 9/30/2007 | 10/31/2007 | 11/30/2007 | 12/31/2007 | |
| 791643 | -240 | -577.8 | -256.8 | -271.2 | -345 | -276 | -276 | -621 | -345 | -276 | -276 | -345 | -240 | -577.8 | -256.8 | -271.2 | -345 | -276 | -276 | -621 | -345 | -276 | -276 | -345 | |||||
| 791647 | -900 | -900 | -900 | -900 | -900 | -900 | -644.49 | -1,155.51 | -900 | -900 | -1,200.00 | -1,200.00 | -1,200.00 | -1,200.00 | -900 | -900 | -900 | -900 | -900 | -900 | -644.49 | -1,155.51 | -900 | -900 | -1,200.00 | -1,200.00 | -1,200.00 | -1,200.00 | |
| 791648 | -352 | -450.24 | -438.12 | -563.3 | -477.24 | -477.24 | -1,073.79 | -1,073.79 | -477.24 | -477.24 | -596.55 | -596.58 | -352 | -450.24 | -438.12 | -563.3 | -477.24 | -477.24 | -1,073.79 | -1,073.79 | -477.24 | -477.24 | -596.55 | -596.58 | |||||
| 791654 | -2,056.22 | -2,056.22 | |||||||||||||||||||||||||||
| 791655 | |||||||||||||||||||||||||||||
| 791657 | -300 | -240 | -240 | -360 | -288 | -288 | -360 | -288 | -360 | -576 | -360 | -300 | -240 | -240 | -360 | -288 | -288 | -360 | -288 | -360 | -576 | -360 | |||||||
<tbody>
</tbody>
