Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2003

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.

Excel tip:

Seeing named ranges as part of the zoom

If you have large areas of named ranges this works better.

If you zoom down to 39% you will see your named range.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.