how do i arrange data

Question

how do i arrange the QListANDAnswer SQL result to be as End result as attached photo..please help because i'm desperately need help..

Nor Azlina Mahmud · Answer

WHY IS NO ONE ANSWER MY QUESTION..PLEASE HELP...

Nor Azlina Mahmud · Answer

i'm combining 2 SQL statement as below to get result as above..my SQL as below : SELECT dbo.QuestionList.que_id dbo.QuestionList.que_bm dbo.QuestionStudAnswer.ag_answer dbo.QuestionStudAnswer.JUM_STUD_ANSWER FROM dbo.QuestionList INNER JOIN dbo.QuestionStudAnswer ON dbo.QuestionList.que_id = dbo.QuestionStudAnswer.ag_que_id

Jaganathan Bantheswaran · Answer

I feel difficult to get your question. Please explain in details like what is the table structure? what is the query you are executing to get the result?