data organization

I have large set of data in vertical form. One pr ID have one or more records against each. i want to organize the data as, the PR ID should appear one time and there records may shown horizontally one by one. I have tried vlookup, pivot table but not find required result. Anybody have idea through macro, formula or other method to solve this. This will increase my knowledge. I will be thankful for the help. The example is show below and file is also at



1938 10.04.2012 10.04.2012 Tech IIT
1938 15.12.2010 15.12.2010 Safety Tech IIT
1938 18.02.2013 18.02.2013 Safety Tech IIT


Pers.No. Start date End Date Training Institute Start date End Date Training Institute Start date End Date Training Institute
1938 10.04.2012 10.04.2012 Tech IIT 15.12.2010 15.12.2010 Safety Tech IIT 18.02.2013 18.02.2013 Safety Tech IIT