cross table issue.

[#1]

I have excel file with column QTR which contains all quarters but when i am loading into the qvw, I want that to be in each quarter in different column.

like below image in final qvd file

[buzzy996]

try tis  way,

in ur script, left(urfieldname,2) as quarter

and use quarter as ur dimension in ur pivot table ,drag the same column on ur pivot table as a header field alsong with ur calculation expressions.