Reorder list of numbers

J

Janek

Hello!

I have to reorder list of numbers. Please help me to find a good way to do
that. I can't do it manually, there is actually much more numbers as in my
example.
Example:
Original list, numbers are simple from 1 to 100:
1
2
3
4
5
6
7
8
9
10
11
12
....
100

Should be like this:
1
11
21
31
41
51
61
71
81
91
2
21
31
41
51
61
71
81
91
3
31
....
100
 
J

Janek

Sorry, I made mistake in my first example!!! The new order should be like
this:

1
11
21
31
41
51
61
71
81
91
2
12
22
32
42
52
62
72
82
92
3
13
23
33
....
100
 
A

Ardus Petus

Create a staging column B with formula:
=MOD(A1,10)

Select A1:B100

Data>sort
1st key: column B ascending
2nd key: column A ascending

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top