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

    Convert dates in different columns without editing Excel

    ra.sae.0

      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