Table re-arrange

[rombo]

Pls, do require a VBA code for rearranging below table, First table is the raw table from which the second table would be genrated, upto 10 names would be there to a max. Tables are pasted using comma as cell separator.

Table:1

Name,Time,Date,Day,Duty
Jeff,5:00,04/09/2011,Sun,Aadab
Jeff,5:30,04/09/2011,Sun,Dublin
Jeff,5:30,04/09/2011,Sun,Gurban
Jeff,5:30,04/09/2011,Sun,Muha
Jeff,6:00,04/09/2011,Sun,Noor-E-Elaahi I;God Bless You
Jeff,6:00,04/09/2011,Sun,Bless
Jeff,6:30,04/09/2011,Sun,Telan
Lisa,7:30,06/09/2011,Tue,Matching
Lisa,8:00,06/09/2011,Tue,Varta
Lisa,8:30,06/09/2011,Tue,Ten aven
Rick,5:00,04/09/2011,Sun,F I R
Rick,5:30,04/09/2011,Sun,Maping zone
Rick,5:30,04/09/2011,Sun,Denm
Rick,6:00,04/09/2011,Sun,Draw


Table2 to be derived from above table:

Day,Time,Jeff,Lisa,Rick
Sun,5:00,Aadab,,F I R
Sun,5:30,Dublin;Gurban;Muha,,Maping zone;Denm
Sun,6:00,Link 2;Bless,,Draw
Sun,6:30,Bless,,
Tue,7:30,,Matching,
Tue,8:00,,Varta,
Tue,8:30,,Ten aven,

Pls Help!

 

[rombo]

Somebody familiar in VBA can help this

 

[rombo]

Help! VOG, Lewiy, pedie

Help to sort this VBA techies