Maria has attended:
Excel Advanced course
Access Intermediate course
Access Advanced course
Excel
If i have a spreadsheet with various column of numbers within a cell i.e.
1 5 7 13 16 17
2 6 8 14 18
3 9 15
4 10
11
12
How can i show this numbers on another speadsheet in order, one following another i.e
1 7 13
2 8 14
3 9 15
4 10 16
5 11 17
6 12 18
Thanks
RE: Excel
Hi Maria
There isn't a short way of doing this as far as I'm aware. It would be manual cutting and pasting and then sorting.