I need to split the data below into 2 records
ie . 01_GF_CR should be 01_GF_NH and 01_NH_CR
how would i go about doing this ? thanks
Line Segment - OnePlan
Route Name - OMEGA
01_GF_CR
01_GF_NH
01_NH_CR
02_GF_CR
02_GF_NH
02_NH_CR
03_GF_CR
03_GF_NH
03_NH_CR
04_GF_DN
04_GF_NH
04_NH_DN
10_EB_ENR
10_EB_EBE
10_EBE_ENR
13_CR_GF
13_CR_NH
13_NH_GF
26_BH_SM
26_BH_IB
26_IB_QS
40_QD_QB
40_QD_IA
40_IA_QB