Converting traded stocks list to Excel

[RIFKI@xxxxxxx]

Hi ! Does any one know how I can get Excel to sort a list of stocks traded for a 
day, like given below, into Open, High, Low, Close,Volume and 
therefore be able to convert to Metastock?

Here is the "trading list". Trades are entered as they happen. I need 
to sort these into Open, High, Low, Close,Volume otherwise I will 
have to enter into Metastock manually each day.

Thanks. And have a nice trading day !

Rifki

            100 ROYAL CERAMICS                  30.50                                   
            100 ROYAL CERAMICS                  31.00                                   
            400 ROYAL CERAMICS                  31.50                                  
          2,400 ROYAL CERAMICS                  30.50                                   
          2,300 ROYAL CERAMICS                  30.00                                   
            600 ROYAL CERAMICS                  31.00                                   
            400 ROYAL CERAMICS                  31.50                                   
            300 ROYAL CERAMICS                  31.00                        
          1,000 SAMPATH 8/- PP                  75.00                                   
          2,700 SAMPATH 8/- PP                  76.00                                  
          1,200 SAMPATH 8/- PP                  75.00                                   
            300 SAMPATH 8/- PP                  76.00                                  
          3,600 SAMPATH 8/- PP                  75.00                                   
          6,600 SAMPATH 8/- PP                  76.00                                  
            300 SAMPATH 8/- PP                  75.00                                   
            100 SAMPATH 8/- PP                  75.50                          
         13,500 SEYLAN BANK                     25.50                                 
         21,000 SEYLAN BANK                     25.25                           
         11,500 SEYLAN MERCHANT                  5.00                                  
            200 SHAW WALLACE                    25.00