6 Replies Latest reply on May 16, 2018 12:55 PM by Wesley Magee

    How to split one column into three columns ?

    kate summer

      I have a dataset with id and major two columns. Knowing that each person only has up to 3 majors. I want to split the maj column into 3 columns maj1, maj2, maj3. My dataset is two columns  The desired output is below. How to do it in Tableau? A sample workbook is attached.

       

      Below is the output I want to achieve:

        

      Thank you