Text Data with CrossTab Report in ReportNet

[ShanChatterjee]

I want to create a CrossTab report in Cognos ReportNet, however my data is Text instead of numbers as:

Table#1

AcctID QuestionData AnswerData
------ ------------ ----------
100006 Name Keith
100006 Address1 51 West Road
100007 Name Ray
100007 Address1 21 Grey Street

I want CrossTab report like this from the above Table#1:

Name Address1
100006 Keith 51 West Road
100007 Ray 21 Grey Street

Is there any way of generating the report as above ? Most of the examples in Cognos ReportNet Help says about Numerical Data, which is not the case here...

Please Help !!!!!!