I had a question -- I have a series of lists of users based on a userid

text string and their name, some of which are duplicates. What i've
done is import the lists into excel and then do a sort by userid.
Additionally, I made a note of which database they're each in, using a
different column for each of the four databases. I first copied all of
the entries from "users1" and then copied "users1" into every row as
column C. Next, I copied the "users2" list and for those, put "user2"
in column D...and so on up to users4.

Now, what I want to do is consolidate the entries, making sure there is

only ONE entry PER userid, but say if a user is in "user2" and "user3"
and thus has those entries in column D and E respectively, I want to
note both. Basically, I just want one row per userid and for each
userid, that row should include all "user(x)" column entries that they
exist in. Any ideas? I could also use access if that would be easier to

do this.


If it helps, I'm eventually going to compile all of these spreadsheets
(which are seperated by computer application they have access to...and
each of these "user(x)" subentries are different authentication
databases within that program)...and attempt to spit out a master list
that has one row per userid with all of the programs they have access
to (we wouldn't need to worry about the 'user(x)' subentries at that
point though, just if they exist in ANY of them).


Thanks much in advance or let me know if something isn't clear...


-Drew