I want to transform data such as;

Col a  Col b Col c
1         13     45
1         17     670  
1         110   32
2          3       51
2         65      540

into;
Col a  1    2     3  
1      45   670  32
2       51   540  

i.e. I want to do a crosstab, where Col C has the values, col b values are
not important but they give the order, and so instead of using colb as the
column headers I want to use a kind of autonumber.

Any suggestions would be much appreciated!

Thanks!