How to Concatenate based on the grouping
265771Jul 30 2003 — edited Aug 4 2003Hi Here is what I need:
Data is existing like this at present:
Here col1,col2..col5 are just column names
col1 col2 col3 col4 col5
bv nm nk ml 1005
bv nm nk ml 1006
bv nm nk ml 1007
bv nm nk ml 1008
bb nn nh bj 1005
bb nn nh bj 1010
bb nn nh bj 1007
bb nn nh bj 1009
The result that I want is:
col1 col2 col3 col4 col5
bv nm nk ml 1005,1006,1007,1008
bb nn nh bj 1005,1010,1007,1009
Can some one help me regrading this...
Appreciate your fastest reply..