Sorting every other line

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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

Similar Threads

How to sort when I have multiple header rows (not included in sor. 1
Sort by Every Other Row? 0
Disney purchase LucasFilm - Star Wars Episode 7 2015 13
stop sorting titles please 3
Sorting Problems 6
Background stays when sorting 2
How to Alphebetize one column, but keep next column together with 2
Sorting issue with frozen panes 11

Back
Top