Make 1 record out of 5

Hi,

I am having say 5 records in a file with same key. each record has a KEY(k1), a price value(p1). there r 5 records in the file like:
k1 p1
k1 p2
k1 p3
k1 p4
k1 p5

can i now using SORT card, get an output file as:
k1 p1 p2 p3 p4 p5?

that is making one records out of the 5 records with all other values in the adjacent fields?

[B]Question asked by visitor Kiran[/b]

I'm not aware of any IBM util that will do this. You could code up an assembler program or if you have it, SAS or any of the other 3rd party products.