98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · Low Priority · Version 2003
Mon 28 Jul 2008, 12:46Delegate Maria said...
Maria has attended:
Excel Advanced course
Access Advanced course
Access Intermediate 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
Tue 16 Sep 2008, 17:12Trainer David said...
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.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Switch between workbooks ni EXCEL.use Alt-TAB to switch between workbooks. |
