0 Replies Latest reply on Mar 8, 2011 7:11 AM by . Janos

    Excel re-shape best practice?

    . Janos

      I have the following Excel file with a survey result:

      http://www.tableausoftware.com/sites/default/files/excel_basis_0.png

       

      The required results I need in Tableau seems like these (red - the problems):

      http://www.tableausoftware.com/sites/default/files/required_results.png

       

      There are minimum 2 different ways to re-shape the basic worksheet with the reshape-tool:

      http://www.tableausoftware.com/sites/default/files/excel_re-shape_2_versions.png

       

      Which is the best method to reshape the worksheet?

      I have difficulties both version, but I haven't enough experiences in Tableau.

       

      Thanks,

      Janos