CLR wrote

I'm sorry David.........I thought you had gotten to the point where
you had only names in one column, with their data in the columns to
the right.........like
ColumnA................ColumnB.....ColumnC
Name........................Data1.........Data2
Brown,Charlie..........address1....address2
Brown,Charlie..........car1...........car2
Brown,Charlie..........wife1..........wife2
Brown,Charlie...........kids1.........kids2
Armstrong,Jack.........address1....address2
etc etc

And was hand-entering Brown,Charlie1....... Brown,Charlie2.........etc
Then Armstrong,Jack1.......Armstrong,Jack2........etc.. .......

I was only trying to point out that
Armstrong,Jack11....Armstrong,Jack12.....etc would sort just as well,
as long as the data within each group was sequential, it not have to
start again with 1,2,etc.......this way it could be concatenated in
instead of having to be typed in.............
Basically what I'm trying to describe is something like this........

NameA.....data.....data.....data.....101
NameA.....data.....data.....data.....102
NameA.....data.....data.....data.....103
NameK.....data.....data.....data.....104
NameK.....data.....data.....data.....105
NameK.....data.....data.....data.....106
NameB.....data.....data.....data.....107
NameB.....data.....data.....data.....108
NameB.....data.....data.....data.....109

Then in the column after the sequential numbers, concatenate the Name
and the sequential number so it reads NameA101, NameA102, NameA103,
NameK104, etc down that column........then sort on that column and
NameB will follow NameA, etc and the data will stay together......

Yeah, that makes sense if data was laid out as you describe. The sheet
layout has to remain as it is (school issued). My followup solution works
fine for me. Thanks for your help and offer.

--
David