Hi Required a solvation for the rule.

[deesh]

Hi,

I have data like:
xx,yy
1,z
1,y
2,x
2,w
My required output looks like:
xx,zz
1,z|y
2,x|w

can any help me out how to solve the above rule

[ray.wurlod]

Vertical pivot then combine the non-key columns into one pipe-delimited column.