Because I saw you post this in an older thread, I thought it might be a good idea to link to it here:
and tag Melinda Morang
This is should actually be pretty easy for you since your data is already in a format that lends itself well to this. You need to load all the origins and destinations into the Route layer's Stops sublayer. When doing the load, just map the "Route Name" field to the Stops sublayer's "RouteName" property. An individual route will be created for each unique RouteName.
Hello Sibel and anyone else reading this thread who might be doing similar workflows.
Esri’s Network Analyst Team is doing some research about customer workflows involving solving routes or calculating travel times and distances between known or preassigned pairs of origins and destinations. It sounds like that's what you're doing here! We’d like to better understand our customers’ needs in this area and may use this information to design and develop improved tools and workflows.
I know this thread is pretty old at this point, but if this workflow is still relevant to you and you have a few minutes and are willing, could you please fill out the attached survey and return it to the e-mail address included inside the document? Alternatively, you can reach out to me (my e-mail address is in the document) to set up a meeting.
Thank you so much!!