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
Bookmarks