I can do this with in the worksheet, but i'd like to do the same with
in VB


Starting with date and numberic values in separate cells in multiple
rows
2/2/2008 1 11/1/2007 12 7/1/2007 1 4/1/2007 2
1/1/08 10 10/1/2007 4 6/1/2007 5 3/1/2007 2
12/1/2007 3 9/1/2007 7


convert above into column
2/2/2008 1
1/1/08 10
12/1/2007 3
11/1/2007 12
10/1/2007 4
9/1/2007 7
7/1/2007 1
6/1/2007 5
4/1/2007 2
3/1/2007 2


sort columns
3/1/2007 2
4/1/2007 2
6/1/2007 5
7/1/2007 1
9/1/2007 7
10/1/2007 4
11/1/2007 12
12/1/2007 3
1/1/08 10
2/2/2008 1


convert above into row, each value in a separate column
2/2/2008 1 1/1/08 10 12/1/2007 3 11/1/2007 12 10/1/2007 4 9/1/2007 7
7/1/2007 1 6/1/2007 5 4/1/2007 2 3/1/2007