1 Reply Latest reply on Oct 8, 2013 10:02 AM by Tracy Rodgers

    Consolidate responses for a two part survey question

    Helen Lindsay

      In an online survey, I ask "How would you describe yourself today?" I give a few options (shareholder, journalist, job seeker etc) and "Other". People who select "Other" are given another list (employee, business partner etc).

      Do I need to consolidate the responses to the two parts of the question into a single column in the Excel spreadsheet? Or can I consolidate them in Tableau? I'd like to do as little manipulation in Excel as possible to reduce the possibility of errors.