Hello, I would like to take 3 questions from a column titled "question text" and make them column headers. The issue I am having is making only those 3 questions a column but leaving the rest of the questions as values under the "question text" column. Attached is a sample that includes which questions should be a column header. Do I need to use 3 filters to pull out the questions, use crosstab and union them back in. Seems like there might be a better way.
Hi @lindani you could use a Find and Replace tool to help remove unwanted questions rather than 3 filters and then cross tab like so:
Thank you so much for the quick reply! I will try this.