Sorting every other line

G

Guest

I created a spreadsheet to list my entertainment collection (movies, music,
etc). I have the title in 1 row, then the description in the next row. For
example:

1 Star Wars
2 George Lucas' film about........
3 Austin Powers
4 Mike Myers stars in this film......

Is there a way that I can sort this spreadsheet by every OTHER row, and keep
the next row together with that sort. In other words I want to sort by title
and have the description linked with that title so it gets sorted along with
the title. Any help would be greatly appreciated. Thanks in advance.
 
D

Dave Peterson

Put the key value (the movie title) in a cell in each row. And add an indicator
to show what row it is.

New Col A B
Star Wars 01 Star Wars ...
Star Wars 02 George Lucas' film about...

Then you can sort using column A as the primary key and columm B as the
secondary key.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top