I have columns instead of rows with data. Transpose does not work with this.

Ad DT
Dis DT
Ap Dt

01/01/08
02/01/08
03/01/08

05/01/08
06/01/08
07/01/07

and so forth. I wan to be able to flag 1st date as 1, 2nd as 2 and 3rd as
3. In between there are blank rows. How do I do this please???