4 Replies Latest reply on Dec 15, 2016 11:34 PM by anand.hariyani

    Need help in using pivot in Tableau.

    Maheshh C K

      Dear All,

      Am stuck in changing the data structure in an imported excel into tableau.

      I wanted to have the data in the below expected output format. Any help here is appreciated.

      Attached the .twbx for the reference.

       

      Input Data:

      Entity

      Factor

      Measurement

      E1

      F1

      1

      E1

      F2

      2

      E1

      F3

      3

      E2

      F1

      4

      E2

      F2

      5

      E3

      F1

      7

      E3

      F2

      8

      E3

      F3

      9

       

      Expected Output:

      Entity

      F1

      F2

      F3

      E1

      1

      2

      3

      E2

      4

      5

       

      E3

      7

      8

      9

       

      Thanks

      Maheshh