Simplifying postal codes for input in TMS system

Hi everybody,

I want to merge different postal codes from Germany into one postal code zone to upload it in a TMS system. Each zone is created by a "from postal code" to a "to postal code".

There are two options for each postal code:
- a transittime of two days - described as "DDE_GNK02A"
- a transittime of three days - described as "DDE_GNK03A"

For example: Postal codes ranging from 01617 to 01619 have a transit time of two days, and therefore needs to be included in zone DDE_GNK02A.

All postal codes have been divided into each of these two zones, however this needs more simplification:

I now have some unnecessary detailed zones, for example:
From postal code 01617 to postal code 01619 = DDE_GNK02A

And the next one in line:
From postal code 01620 to postal code 01623 = DDE_GNK02A

As this is the same zone, it can be specified easier as:
From postal code 01617 to postal code 01623 = DDE_GNK02A

As my file has about 8000 different rows with these postal codes, I was wondering if there could be a formula which can simplify my file.


Thanks and regards,
Aron

If the postal codes in the next row are in the same zone as the previous one, then I want to merge this.

current situation:
Row 1: From postal code 01617 to postal code 01619 = DDE_GNK02A
Row 2: From postal code 01620 to postal code 01623 = DDE_GNK02A

change to:
Row 1: From postal code 01617 to postal code 01623 = DDE_GNK02A
Row 2: can be deleted

hope this helps.

It worked perfectly, thanks Glenn!

You saved me a lot of time and frustration :-)