Export pivoted data in excel

/* Create a webapi object and place the below code */

a!localVariables(
  /*call your table to fetch two columns and all the rows*/
  local!data,
  local!questionRow: concat(
    a!forEach(
      items: local!data,
      expression: { fv!item.questions, "," }
    )
  ),
  local!answerRow: concat(
    a!forEach(
      items: local!data,
      expression: { fv!item.answers, "," }
    )
  ),
  a!httpResponse(
    /*
    * Set an HTTP header that tells the client that the body of the response
    * will be a CSV attachment.
    */
    headers: {
      a!httpHeader(
        name: "Content-Disposition",
        value: "attachment; filename=" & char(34) & "Test.csv" & char(34)
      )
    },
    /*
    * Create a CSV value of 'local!questions', 'local!anwers'  and place it in the response body.
    */
    body: {
      local!questionRow & char(10) & local!answerRow
    }
  )
)

Thanks for the reply,  I did try this ,but all answers are coming in one row

After responded by ,data should have flown to third row, something i might be missing here?

Thanks for the reply,  I did try this ,but all answers are coming in one row

After responded by ,data should have flown to third row, something i might be missing here?

you would need to modify the logic in local!answerRow so that for every row you need to insert char(10) at the end and then start concat again (something like that)

Thank you!