3 Replies Latest reply on Feb 8, 2019 2:59 PM by Deepak Rai

    Long format to Wide in Excel

    Scott McDaniel

      This is basically an Excel question.  How do I reshape from Long to Wide format.  I have the Tableau Add in that allows to go from Wide to Long format, but I need to re-reshape the data the other way.  Is there an easy solution to this? Here is a sample of our file.  The reason we need to do this is that we added a question and merged two questions into the survey and changed the one 5-point Likert to a 7-point to match with the others.  And, our new data is, of course, in wide format.  We no longer have the original Excel file where the near 100K rows of (long form) data were reshaped.  Any help would be much appreciated. 

      Reshaping-Long to Wide.png