3 Replies Latest reply on Nov 6, 2016 11:08 AM by Marc MOUSSA

    Pivot with mutliple values?

    Carlton Lee

      I conducted a survey in Survey Monkey that asked about ethnicity. Respondents could select multiple answers (e.g. Asian, Asian Indian, Japanese, etc). When this data is exported to Excel and then imported into Tableau, every possible answer constitutes a column:

       

      Screen Shot 2016-11-06 at 10.36.43 AM.png

      Is there way to pivot this data into a single ethnicity column?