How to Alphebetize one column, but keep next column together with
 

Hi all, I have a list of movie titles in one column and the CD number on
which the movie is found, in the next column. How do I sort the movie titles
by alphabetical name in column one, while keeping the disk number in the next
column together with the title, so that I know what disk it's on? I've been
trying to figure this one out for days now - please help :)

For example....

TITLES DISK #
Days of Thunder 1
Armegeddon 2
Jurassic Park 3

I would like it to look like

TITLES DISK #
Armegeddon 2
Days of Thunder 1
Jurassic Park 3

If anyone can figure this out, I'd really appreciate it - thanks!

How to Alphebetize one column, but keep next column together with
 

Hi

Select both columns, goto Data Sort Sort by: Column A (Titles)

Regards,
Per

"EvasiveFox" skrev i meddelelsen
...
Hi all, I have a list of movie titles in one column and the CD number on
which the movie is found, in the next column. How do I sort the movie
titles
by alphabetical name in column one, while keeping the disk number in the
next
column together with the title, so that I know what disk it's on? I've
been
trying to figure this one out for days now - please help :)

For example....

TITLES DISK #
Days of Thunder 1
Armegeddon 2
Jurassic Park 3

I would like it to look like

TITLES DISK #
Armegeddon 2
Days of Thunder 1
Jurassic Park 3

If anyone can figure this out, I'd really appreciate it - thanks!

How to Alphebetize one column, but keep next column together with
 

Hio,
Select both columns and then sort by column A

"EvasiveFox" wrote:

Hi all, I have a list of movie titles in one column and the CD number on
which the movie is found, in the next column. How do I sort the movie titles
by alphabetical name in column one, while keeping the disk number in the next
column together with the title, so that I know what disk it's on? I've been
trying to figure this one out for days now - please help :)

For example....

TITLES DISK #
Days of Thunder 1
Armegeddon 2
Jurassic Park 3

I would like it to look like

TITLES DISK #
Armegeddon 2
Days of Thunder 1
Jurassic Park 3

If anyone can figure this out, I'd really appreciate it - thanks!