DSXchange

Hey everybody
Have a quick question about one of the issues in parallel , can you let me know what is the best way to compare rows in parallel ?
Scenario
I have rows like
a xyz
a pqr
a yrd

Functionality needed
Compare row 1 and row 2 if the entry in first row is same (here a ) then comcatenate column 2 values and make it as
a xyzpgr

Any idea what stage to use here?

This is a pivot requirement (rows to columns), search the forum for "Pivot".

Vertical pivot.

I'm assuming the output should actually end up as:

a xyzpgryrd

Yes?