Concat the Rows for Same ID
642000Jul 5 2012 — edited Jul 5 2012Hi All,
I want to merge rows in one row for e.g column 1, column 2, column 3, column 4 are same ,but column 4 and column 5 are diffrent, I want to merge in one row.
Below is data:
column1 column2 column3 column4 column5
123 abc xyx a b
123 abc xyx e k
123 abc xyx w h
124 sss ttt r f
124 sss ttt q p
124 sss ttt z m
Below is the Result:
final row
123 abc xyz abekwh
124 sss ttt rfqpzm
Regards,