The example belowis the result I'm looking for:

SOURCE DATA:

A B C
D E
SCOTT 12 ABC 2.00 5.5
SCOTT 12 ABC 2.00 5.5
DAVE 12 ABC 2.00 5.5
JACKIE 12 ABC 2.00 5.5
SCOTT 12 ABC 2.00 5.5
JILL 123 ABC 7.00 5.5
JILL 123 ABC 7.00 5.5
JILL 123 ABC 7.00 5.5
JILL 123 ABC 7.00 5.5
DAVE 12 ABC 2.00 5.5
JACKIE 12 ABC 2.00 5.5

END RESULT:
SCOTT 12 ABC 2.00 5.5
SCOTT 12 ABC
DAVE 12 ABC 2.00 5.5
JACKIE 12 ABC 2.00 5.5
SCOTT 12 ABC 2.00 5.5
JILL 123 ABC 7.00 5.5
JILL 123 ABC
JILL 123 ABC
JILL 123 ABC
DAVE 12 ABC 2.00 5.5
JACKIE 12 ABC 2.00 5.5

Basically evaluate column A, B, C, D, E, when the second row repeats
then remove values in column D, E (or replace with 0.00.