REVERSE PIVOT (SOURCE ---> SORT ---> TX ---> REMOVE DUPLICATES ---> TARGET) Step by Step With Screen Shot

Source Data 

COMPANY,LOCATION 
IBM,CHENNAI 
IBM,HYDRABAD 
IBM,PUNE 
IBM,BANGLOORE 
TCS,CHENNAI
TCS,MUMBAI
TCS,BANGLOORE
WIPRO,HYDRABAD
WIPRO,CHENNAI
HSBC,PUNE

Importe into Sequential DataStage
Flow Chart 

Use Cluster Key option in sort stage 

This is one way for implemnting this....

First you sort the data - cluster sort - later you can use transformer for concatenating the data based on cluster key....

Creat 2 STAGE VARIABLE AND MAP TO DERIVATION AFTER APPLYING CONDITION IN SV 

Thanks & Regards,
Siva