Is it possible to create an inline table with carriage returns in the data?

[#1]

I need to manipulate some data from our ERP system but am struggling.

For each sales order there can be more than one question and answer.

QandA:

LOAD * INLINE [

Order, Seq, Question, Answer

SO1, 1, What is your name?, Simon

SO1, 2, What is your favourite colour?, Blue

];

I only want to see one line per sales order, with all it's answers and questions.

QandA_v2:

LOAD * INLINE [

Order, Questions(s), Answers(s)

SO1,"What is your name?" & chr(10) & chr(13) & "What is your favourite colour?", "Simon" & chr(10) & chr(13) & "blue"

];

The above will not work as the chr(10) chr(13) are just seen as new rows.

Is there any way I can create a table with carriage returns in the data?

Regards

Mark

[#2]

What is the business logic for such data? How are you going to use it for BI analysis?

[disqr_rm · Accepted solution]

Something like this?

QandA:
LOAD * INLINE [
 Order, Seq, Question, Answer
 SO1, 1, What is your name?, Simon
 SO1, 2, What is your favourite colour?, Blue
];
FinalQ_A:
LOAD Order,
 concat(Question & ':' & Answer, chr(10), Seq) as QandA
RESIDENT QandA
GROUP BY Order;
Drop table QandA;

[#4]

Exactly what I needed thanks, seems so simple now

[#5]

There is none. The customers export this particular chart to excel and email it to colleague who do not have Qlikview. They want to see all the data at order level.