Sort Table From A-Z

[goro2010]

Good Day,

I have a table that I already have the "Order By" scripted in, preview is below:

Order By EventId,DateTimeFrom,DateTimeTo,AccountId,PersonId,[Visit Date];

The problem I have is the following:

I need to sort the table "Sales Rep Scanned" other wise the data is not corresponding.

This is how it looks without the sales rep selection, this is displaying wrong information.

This is how it looks when I make the sales rep selection, this is the correct information, so I need to get the sales reps in the table from A-Z.

Any idea if this can be done?

Thanks