How to concatenate values from similar keys

[gagan8877]

Hi

I have a sequential file that contains the following values:
"Col1", "Col2"
"1","a"
"1","b"
"1","c"
"2","d"
"3","e"
"4","f"
"4","g"

I need to combine the values with similar key values (column 1). So the output should be:

"1","abc"
"2","d"
"3","e"
"4","fg"

Please guide me how to do this?

Thanks

[DSguru2B]

Search the forum for examples of vertical pivot. It can easily be done by the classic approach of doing key comparisons between present and previous key and storing the values in stage variables.