Delete sequence of rows with same values, while copying data from a cell to another

Hey everyone, I need to reduce the number of rows of a shipping range worksheet that's following a "from zip" / "to zip" and "from weight" / "to weight" method, and has more than 400 thousand rows and 8 columns.

I need to clean these rows because there are thousands of redundant lines in sequence that should be grouped together.
They have the same values, so they should be in a single row with a wider shipping range.

So the need is actually to detect sequential rows that have the same values in all columns except in columns A and B (that`s the shipping range), and when a sequence of rows meets this condition, we need to copy the value from the last row to the first row of the "To zip" column (column B), and then delete the extra rows.

Here is an image that illustrates better what needs to be done:
Excel-forum-image.jpg

I also attached a smaller version of the worksheet (you can see examples of redundant sequential rows at lines 2482, on the last rows and on hundreds of other rows throughout the worksheet).

If I can`t find an automated way of doing this I'm gonna have to do this by hand, so please help if you know how to accomplish this..

Your effort is greatly appreciated.. Thanks in advance!