View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jspagnoli
 
Posts: n/a
Default Sorting every other line

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.