3 Replies Latest reply on May 16, 2018 12:39 AM by Zhouyi Zhang

    How to Breakdown Column based on value from another coloumn

    amardeep bedi

      I have data  in following shape,   

         

      IDData NameData Value
      A1Site NameSydney
      A1Premises6900
      A1D_IDWL386
      A2Site NameMelbourne
      A2Premises7000
      A2D_IDWL286
      A3Site NameDarwin
      A3Premises1568
      A3D_IDWL186

       

      And i Want to convert to data in following  Shape to generate my reporting, This data is available on tableau server, so i want to do it in tableau  not in excel , please advise me if there is any way to do this.

       

          

      IDSite NamePremisesD_ID
      A1Sydney6900WL386
      A2Melbourne7000WL286
      A3Darwin1568WL186

       

       

      Regards