how to separate data in cell into separate cells , sorted by value

hi gatti, thank you so much for taking the time to get back to me - and for solving my problem. i've tried to apply the formula you suggested to the actual spreadsheet - but i can't seem to figure out how to adapt the formula you created. for simplicity i had just provide a summary of the problem in my original post. the actual xls report is attached. hate to ask you for more help, but could you look at the attached . the spreadsheet is in the format that it will be generated by the online entry system. the cell that i will need separate is column W. the final version will have about 4000 rows. thanks again !