Hi,
I have a list of postal codes arranged on 1 column of around 13000 rows.
Some of these postal codes could be collapsed and setup in ranges since they are consecutive like in the example below:
121012 and 121013 could be collapsed in 1 row as Low:121012 High:121013
<tbody>
</tbody>
Anyone with a solution to this?
I have a list of postal codes arranged on 1 column of around 13000 rows.
Some of these postal codes could be collapsed and setup in ranges since they are consecutive like in the example below:
121012 and 121013 could be collapsed in 1 row as Low:121012 High:121013
Country | IATA Code | Low | High | Low | High | |
India | IN | 121012 | 121012 | 121012 | 121013 | |
India | IN | 121013 | 121013 | 121101 | 121101 | |
India | IN | 121101 | 121101 | 121103 | 121103 | |
India | IN | 121103 | 121103 | 121105 | 121107 | |
India | IN | 121105 | 121105 | 122052 | 122052 | |
India | IN | 121106 | 121106 | 122104 | 122104 | |
India | IN | 121107 | 121107 | 122108 | 122108 | |
India | IN | 122052 | 122052 | 122413 | 122414 | |
India | IN | 122104 | 122104 | 122502 | 122506 | |
India | IN | 122108 | 122108 | |||
India | IN | 122413 | 122413 | |||
India | IN | 122414 | 122414 | |||
India | IN | 122502 | 122502 | |||
India | IN | 122503 | 122503 | |||
India | IN | 122504 | 122504 | |||
India | IN | 122505 | 122505 | |||
India | IN | 122506 | 122506 |
<tbody>
</tbody>
Anyone with a solution to this?