I need to take a column that is in this format:
1/1/06
1/1/06 total
1/4/06
1/4/06
1/4/06 total
2/7/06
2/7/06 total
and so on

and make it into a column heading automatically, so that any time the dates are changed or the totals move or anything, the dates at the top row automatically change with it

1/1/06 1/4/06 2/7/06, etc

in column c1:m1 and c2:m2 I put these formulas
c1=SMALL($A$2:$A$50,B2+1)
c2=COUNTIF($A$2:$A$50,C1)+B2

there is nothing in column b, but in column d-m it calculates the occurances of all previous dates to know where to start the SMALL function from