Suppose my excel sheet looks like this:
A
1 10
2 9
3 8
4 7
5 6
6 5
7 4
8 3
9 2
10 1

Now in B1 i want A10A9A8A7A6, i.e. 12345 then in B2 i want A5A4A3A2A1,
i.e.678910.

This is a simplified version of my problem. I have a column of 1000 numbers:
- i want to take the first 5 numbers and arrange them in reverse order,
- keep doing this for all the 1000 numbers in the column.

How can i do this without manually performing the work?