2 Replies Latest reply on Jul 24, 2012 8:46 AM by Joseph Pirraglia

    Take The Values In A String And Separate Them Into Individual Cells

    Joseph Pirraglia

      Is there a way to separate a string of values in one cell into many individual cells in Tableau? Each value is separated by a space.

       

      Below is a sample of the dataset. I have also attached a TWBX file as well. I am trying to create a graph of these values.

       

      FROM THIS:

      11.4599498963099 11.5703091136415 11.7118539202175 8.98437587621149 9.09766964349922 9.18930930143244

       

      TO THIS:

      11.4599498963099

      11.5703091136415

      11.7118539202175

      8.98437587621149

      9.09766964349922

      9.18930930143244

       

      The whole data set has about 120 values in one cell. Not sure if Tableau can break this out.

       

      Any help would be appreciated thanks!

       

      Joe