Split column and replace with associated fields and concatenate

[Arjunmallik_2019]

Hi experts,

I have a field with information separated by '/' and this filed include Null values also i.e,"Route Segment" in the below example.
I need to create one more filed "Route Sales" based on filed "Route Segment".

Input

"RouteSales" filed logic should be based on SalesRepID.
Routesegment is based on Segments  and it is a concatenation of segments
"Route Sales" is a concatenation of salesRepID but it will have some null values as same as in 'RouteSegment'

output

Could you please help me on this.