data selection

[james123]

Hi, currently I have minute to minute stock index futuresans spot return. I want to re-arrange the data. My original data is order as the following format:


4/19/2012 02:31 0.061260
4/19/2012 02:32 0.000000
4/19/2012 02:33 -0.038283
4/19/2012 02:34 -0.030637
......


But I want to re-rerange it as following:
xxxxxxxxx 02:31 02:32 02:33 02:34 ............................

4/19/2012
4/20/2012
4/21/2012

and I have tried to use the commond "wide +/-" but it can only work out for 5 mins. I want sort all the daily data to one row.

And I attached my data in this file, and the data name in the file is called as "f" and "s".

Many Thanks