3 Replies Latest reply on Oct 5, 2016 6:55 PM by Akriti Lal

    Convert Measures - column to Dimension - data is not in excel, so Pivot not possible

    Jone Kutty

      I have data in following type of table, I would like to Merge Measures / Columns to create Dimension, is it possible?

       

      Data is not in Excel, it is in SQL Server, so pivot option does not work. Can someone share their ideas  on how do i go from Current Table to Expected Table?

       

      Current Table

        

      Material9/26/20169/27/20169/28/20169/29/20169/30/201610/1/2016
      A1245766
      B332655673
      C366566
      D4567566
      E456566

       

      Expected Table:

       

         

      MaterialDateValue
      A9/26/20161
      A9/27/20162
      A9/28/20164
      A9/29/20165
      A9/30/201676
      A10/1/20166
      B9/26/20163
      B9/27/201632
      B9/28/201665
      B9/29/20165
      B9/30/201667
      B10/1/20163
      C9/26/20163
      C9/27/20166
      C9/28/20166
      C9/29/20165
      C9/30/20166
      C10/1/20166
      D9/26/201645
      D9/27/20166
      D9/28/20167
      D9/29/20165
      D9/30/20166
      D10/1/20166
      E9/26/20164
      E9/27/20165
      E9/28/20166
      E9/29/20165
      E9/30/20166
      E10/1/20166

       

      Thanks