Help with the data manipulation

["Chen,Sichong" <sichong.chen@postgrad.manchester.ac.uk>]

Dear User

Could you be so kind to help me with this question.

I have data set (11*3) like this:

1001    19950101        123     
1001    19950102        234     
1001    19950103        345     
1002    19950101        1234    
1002    19950102        2345    
1002    19950103        3456    
1002    19950104        4567    
1003    19950101        12345   
1003    19950102        23456   
1003    19950103        34567   
1003    19950104        45678   

I would like to transfer it to 

        1001    1002    1003    
19950101        123     1234    12345   
19950102        234     2345    23456   
19950103        345     3456    34567   
19950104        NA      4567    45678   


1001, 1002, 1003 could be column names, or just ignore them as they are used
to identify which column the data should be allocated. 

Function merger is unlikely to be used in my case because I have thousands
of blocks, which means from 1001 to 7000.

Any suggestion is appreciated. 

Many thanks,
Sichong
SPlus 7.0 & FinMetrics 2.0 User
Windows XP