13 Replies Latest reply on Oct 22, 2016 9:43 AM by Łukasz Majewski

    Convert dates in different columns without editing Excel


      Hi Team,


      One of my students had the below doubt and I couldn't get the best solution.

      Please help me on changing multiple columns in Excel into two columns Dates & Values without editing the excel.

      The excel will be updated on a regular basis hence modifying the structure on Excel is not possible.


      Excel file looks like the attached one / Below screenshot.


      We need to import dates and values into two columns for creating dashboards on Tableau. I couldn't make use of Pivot or Data interpreter.


      Date               Value

      1/1/2015          123

      1/1/2016          123124