most of the code and help is on removing duplicates. however, my problem is
that my duplicates data occur becos my other dept key in data w/o a standard
format and we can not make changes to the main data sheet except to sort it
out to other sheet ourself.I will need to combine data from both duplicates
into one data.

Illustration:

orginal data:
Name Jan Feb March
alan 0 0 1
alan 1 0 0

what i want in the end:
Name Jan Feb March
alan 1 0 1