Sort 1|3|5|7|9|11|13|15|17 to 1|11|3|13|5|15|7|17|9|

So i have a dynamic spreadsheet providing the numbers 1.. a given value (in this case 17). 1,2,3,4,5,6,7,.....,17
I have sorted the numbers into two rows providing either odd or even numbers.

*My next step is to sort it like this: || = a cell

Row 1: |1|3|5|7|9|11|13|15|17| ->|1|11|3|13|5|15|7|17|9|
Row 2: |2|4|6|8|10|12|14|16| -> |2|12|4|14|6|16|8|10|

As you can see the patters is every other value. My problem is that the limit of the input value strech from 12 to 102. And the sheet must still provide this pattern...

Thanks

It's unclear:

a) how you're deriving the values
b) where you want to sort the values (in-situ, or elsewhere)
c) whether the values need to remain as numbers
for ex. were you to store as text strings you would find you can sort per your requirement quite easily (using native sort), i.e. "11" > "1" and < "3")

Perhaps post a sample file to illustrate what you're doing, exactly.

Use GoAdvanced -> Manage Attachments
{the paperclip icon does not work, unfortunately}