organize the data--Help!
Hi, I'm assigned an task that to organize one file like this:
original table:
sn# ref# cir# ID#
4232 23 OT111000 F1000
4545 23 OT111000 F1001
8686 45 OT111000 F1002
8989 46 OT118989 F4230
7899 46 OT118989 F4231
the table wanted:
If Ref# and cir# are same, concatenate ID# together, like sample below:
sn# ref# cir# ID#
(any) 23 OT111000 F1000, F1001
8686 45 OT111000 F1002
(any) 46 OT118989 F4230, F4231
I like to run a macro to complete this because the table has tons of
records. Can anyone help me on this?
Any help would be greatly appreciated.
Sarah
|