Hi All,

i have 10 columns iwant put alll these 10 columns in to 2 columns i there any workaround please let me know.

thanks,
Kalyan

I don't understand this question.

I think what you're looking for may be a SQL Decode or CASE statement.

sounds like you're just converting columns to columns. try using a DEFINE. Otherwise, try the McGyver technique or one of the other solutions which have been posted numerous times. You can probably do a find on "columns to rows" and get a bunch of hits.

Hi i dont want to convert columns to columns.
i will explain clearly,
TABLE FILE ABCD
PRINT
ABC
COMPUTE aCTUAL/D12=....;
COMPUTE ASD/D12 = ;
COMPUTE DDD/D12=;
BBC
COMPUTE XCTUAL/D12=....;
COMPUTE AXD/D12 = ;
COMPUTE XDD/D12=;
aCROSS VVVV
END

THIS IS THE REPORT I WANT TO ARRANGE THE ABOVE REPORT TO BE LIKE THIS
ACROSS VALUES
------------
ABC ACTUAL 222 222 222
ASD 342 11 11
DDD 234 123 11
BBC XCTUAL 112 332 33
AXD 22 22 35
XXD 121 231 34

I WANT THE OUTPUT LIKE ABOVE.

I"m not exactly sure what you want...but try using OVER.