Group Rows to Sort

[jeff]

Hi, Viki,

Well, first you have to keep the tape name with each
spot; in other words you won't be able to have
Name-A in cell A1, blank Cells A2-A10, yet TapeA
spots in cells B1 thru B10 - you need both for each
row in order to sort.

won't work:
MyDog 10
20
30
MyCat 14
18
20
You'll need:
MyDog 10
MyDog 20
MyDog 30
MyCat 14
MyCat 18
MyCat 20

(or at least a hidden column with all the tape names for
each spot and use THAT to sort on.)

I hope I've understood your question.
jeff

-----Original Message-----
I am creating a spreadsheet to log tapes. Column A is

the Name of the tape. Column B is the names of the spots
on each tape. Each tape could have up to 10 spots on it.
Therefore, I can have a tape name with 10 rows belonging
to it. How can I sort by Column A (Name of Tape)
alphabetically, while keeping all the spot names in
Column B sorted with it?

 

[Viki]

I guess I'll have to do the hidden column trick. Thanks for your help.

-viki