The full data view is using alphabetical order minus the numbers you have put in. That's the logic, and now we just need to figure out how to get them in number order. Give me a few minutes to look over your workbook.
This thread looks like it's about your same issue: How do i change the order of columns in exported data from a published tableau workbook via tableau server.
They discuss some other workarounds and it's an entertaining read besides.
If this helps please mark the answer correct.
Thank you for responding to me! I can see that my sample data did it alphabetic excluding the numbers, but my original data doesn't?
Hm, I will look at the workarounds they are discussing, but seems like they are suggesting the numbers solution as the working solution?
Yes, they did suggest the number solution, which strangely does not work for your Server use case.
There was also a suggestion to put your columns in a particular order first, then show your data. If you can set a consistent order (maybe using a default sort) you might be able to keep the order consistent in the view data pane as well.