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