Data Manipulation

[sanjimmy]

Would like if the below result can be achievable and what method..
Sample data:

2003 sanny sony
2002 sanny sony
2002 sinsing pansonic
2002 dee tee
2003 dee tee
2004 dee tee
2005 ada hoa
1995 kii kiwi

Desired Result

2003 sanny sony 2003-2002
2002 sanny sony
2002 sinsing pansonic 2002
2002 dee tee 2004-2002
2003 dee tee
2004 dee tee
2005 ada hoa 2005
1995 kii kiwi 1995

Thanks,
Jimmy

[abcd]

do you need it once or to be a premade macro ?

[sanjimmy]

Thanks all..I get the solution from other source..

Jimmy.