4 Replies Latest reply on Jun 1, 2016 1:30 AM by DIVYA BHARATHI

    Excel Data preparation

    Y K

      I have following type of Excel data and try to prepare for Tableau.

       

      I used Tableau Excel Add-in - ‘Reshape data’. But still not enough.

      The 4th row [Col4] is still contain multi values.

      I want to split [Col4] to 3 rows like [Sales], [Profit] and [Quantity].

       

      If I change some steps, can I make it?

      Or any other way?

      Please let me know any advice.