Spliting data in the single column into two columns in impromptu

[bidw1]

I have to split the data in single column into two columns as shown below in impromptu report.

Column1
Y
Y
N
N

The report should have two columns where above data in the column1 should split into two columns as below

column A Column B
Y N
Y N

Please advise on the approach to resolve this issue.Advance thanks for your time and help.

anan

 

[drlex]

Suggest you look at Crosstab reports. Alternatively, you might get your DBA to provide a view on the data to suit.

soi la, soi carré

 

[bidw1]

Thank you very much for your advise

This report is saved as iqd and used in trandformer.
Making it into crosstab will have impact on the cube data? is there any way i can achieve this in the list report.

Anan