Input
- IssuingCompanyCd,013550
PolOfficeCd,000130
PolicyNo,WR101
CertificateNo,101010
RenlCertNo,000000
EndorsementEffDt,01012008
EndorsementSqn,1
Output
IssuingCompanyCd,PolOfficeCd,PolicyNo,CertificateNo,RenlCertNo,EndorsementEffDt,EndorsementSqn
013550,000130,WR101,101010,000000,01012008,1
First row is as header in this case
I have tried use pivot, Row Merge without much of luck
Thanks In advance,
Tushar