14 Replies Latest reply on Jun 6, 2018 7:56 AM by Deepak Rai

    How to reformat an excel table so Tableau is able to read it?

    Chadi Atie

      Hey guys,

       

      I have an excel sheet (small sample attached Sheet1) with an unreadable format in Tableau.

       

      I want to reformat it in a way that Tableau is able to read it so I can run my analysis.

      I manually reformatted the sample to let you see how I want my table to look like in order for Tableau to read it. (attached Sheet2)

       

      Is there any way to do it via Tableau or via any other tool?

       

      Thanks a lot

       

      Chadi