Sorting every other line

[Jspagnoli]

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.

[Don Guillett]

Wouldn't it be easier to have
1-2 start wars George
3-4 Austin
etc
--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Jspagnoli" <Jspagnoli@discussions.microsoft.com> wrote in message
news:484BE134-EE4B-447A-8A60-DE69B9DE694A@microsoft.com...
>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.

[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.

Jspagnoli wrote:
>
> 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.

--

Dave Peterson