I have a text file (comma seperated) which lists a model in the format you see below. When I import this into an SQL table and it looks like it does below.

Is there any way to check the model field to see if there are two models the same in this field and then join this record, so it reads like example 2.

Example 1.
Model Achievement Plan Achievement Date Actual Achievement Date
----- ----------- --------------------- -----------------------

502 01 01/02/2005 02/02/2005
502 02 01/02/2005 02/02/2005
503 01 03/01/2005 17/12/2005
504 04 09/03/2005 09/03/2005

Example2.

Model Acht PlanAchDate ActualAchDate Acht PlanAchDate ActualAchDate
----- ----- ------------ -------------- ----- ------------ --------------
502 01 01/02/2005 02/02/2005 02 01/02/2005 02/02/2005