Interesting - Reorder road segments in a corridor

[user90]

Please help me in writing the formula. Because of match first occurence it is getting repeated.

I have "From", "To" NODE IDs of road segments which are not in order and needs to be reordered. I found the two unique values which are first node and last node of the corridor and started with one.

D2=E2
E3 =IF(INDEX($B$3:$C$33,IFERROR(MATCH($D3,$B$3:$B$33,0),MATCH($D3,$C$3:$C$33,0)),1)=D3,INDEX($B$3:$C$33,IFERROR(MATCH($D3,$B$3:$B$33,0),MATCH($D3,$C$3:C33,0)),2),INDEX($B$3:$C$33,IFERROR(MATCH($D3,$B$3:$B$33,0),MATCH($D3,$C$3:$C$33,0)),1))

SlNo	From	To	Reorder From	Reorder To	Row Occurrence
1	100028	329136	100028	329136	1
2	100192	329149	329136	100196	10
3	100192	329182	100196	329027	9
4	100193	100558	329027	329137	27
5	100193	329147	329137	328011	25
6	100194	100425	328011	329137	25
7	100194	329189	329137	328011	25
8	100195	329059	328011	329137	25
9	100195	329139	329137	328011	25
10	100196	329027	328011	329137	25
11	100196	329136	329137	328011	25
12	100425	329144	328011	329137	25
13	100558	100646	329137	328011	25
14	100618	100619	328011	329137	25
15	100618	100656	329137	328011	25
16	100619	100620	328011	329137	25
17	100620	100621	329137	328011	25
18	100621	325013	328011	329137	25
19	100646	329189	329137	328011	25
20	100654	325012	328011	329137	25
21	100654	329185	329137	328011	25
22	100655	100656	328011	329137	25
23	100655	329186	329137	328011	25
24	320001	325013	328011	329137	25
25	325012	329186	329137	328011	25
26	328011	329137	328011	329137	25
27	328011	329139	329137	328011	25
28	329027	329137	328011	329137	25
29	329059	329143	329137	328011	25
30	329143	329144	328011	329137	25
31	329147	329149	329137	328011	25
32	329182	329185	328011	329137	25

<tbody>
</tbody>

Thank you very much in advance.