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.............
If your data was in that order, you could have just put sequential numbers
in a helper column, starting with 101 at the top and incrementing down as
far as you have data(actually101 instead of 1 in case you have more than 9
rows for a name to prevent it sorting 1,10,2, etc)..........then in the next
helper column you could have CONCATENATED column A (the name) with the
sequential number in that helper column, and then copied this formula down.
This method will give you a unique name-number combination for each row,
sequenced within each group, and they will sort and stay together. If you
can get to that point on your own, that would probably be the easiest way to
be able to sort by name and keep the associated data together with the name.
I've done this with several thousand row databases with varying numbers of
data lines for each principal. It works good. If you cannot get to that
name/data configuration described above then send me a sample of your
worksheet ( to my home addy, not the newsgroup), and I will try to bust it
out for you. If you do, send enough lines as to be typical of the whole
thing........
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......
I've also seen posts in these newsgroups whereby Macros were offered to
break data similar to yours out to all read on one row.........that might be
an alternative.......unfortunately, not my area of expertise, but if you are
interested in that approach, post back in a new thread and someone will no
doubt be able to help with that. Otherwise, we'll keep at this one until
you have something you can use.
Vaya con Dios,
Chuck, CABGx3
"David" wrote in message
...
CLR wrote
Followup on your followup <g
Although the concatenated suffix's must be in sequence for each group,
they need NOT start with 1 each time..........sooo, you could just use
another helper column with numbers sequenced from 1-XXXX, and then
concatenate the names and the respective row from this new column, so
it might read,
Brown,Charlie1....Brown,Charlie2......Armstrong,Ja ck12......Armstrong,J
ack13 , etc etc..........would make the initial setup easier, just
type in one formula and copy down................
Ok, I follow the first part (sequenced numbers in another helper column),
but then I get lost with 2nd (concatenate names and the respective row
from
this new column).
Test data:
Col A = names followed by 3 rows of data in Col A, B & C
Col D = 1st helper column with ??? formula to copy down
Col E = 2nd helper oolumn with sequenced numbers
I'm lost.
--
David
|