rows to colums using pivot stage

[ramsdanda]

Hi ,

Anybody help me regsrding Pivot stage , my requrement like this i need to interchnage rows to coloums.

Ex: input is like A, Card1,100
A,Card2,200
A,Card3,300

My out should be like this A,Card1,Card2,Card3
100, 200, 300 (data) can u please help me how implement logic using pivot stage . plese treat it as very urgent.

Thanks&Regards
Ramesh

[rasi]

First do a search on the forum for Pivot....

For Urgent you need to hire consultant immediately...In DSXchange urgent = ignore

[kumar_s]

This cannot be acheived by PIVOT stage. But by search.

[ray.wurlod]

A good search topic would be vertical pivot. Several techniques exist.