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
    }
  )
)