I am having issues with the QuestionText fields in my query below. I am trying to take all the QuestionText entries and display them as columns, however after transposing those fields, the other columns I had listed for my table have become rows. How can I transpose the QuestionText fields while keeping my other columns and not getting that mysterious "column" at the beginning of my table? See below:
index=xxx source=xxx
| dedup QuestionID
| eval QuestionText= SectionTitle + " " + QuestionText
| sort QuestionID
| table "Date Created" "Created By" "Vendor Name" "Risk Rank ID" Criticality "Risk Rank Score" QuestionText QuestionAnswer
| transpose 0 header_field=QuestionText
