Using Crosstab to make questions into column headers.

[lindani]

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.

[JoeHerbert]

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: 

[lindani]

Thank you so much for the quick reply!  I will try this.