A very straight forward way:

Select Column C and D Copy paste special values

Delete Column A and B

Sort columns A and B by A descending.

edvwvw