Forum Discussion

maati1980's avatar
maati1980
Frequent Visitor
8 years ago
Solved

Dates as Column headers

My input data has Years and month date as a column header. Can I transpose it into rows? To illustrate my data has the following form: Customer Product 2018.01 2018.02 Customer A Product ...
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi maati1980,

     

    To achieve your requirement, click Query Editor-> Transform-> click on colunm [2018.01] and [2018.02] -> Unpivot Columns, then rename "attribute" and "value" to "Time" and "Sales".

     

     

    Regards,

    Jimmy Tao

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

You would unpivot those columns. The best way would be to select your first two columns and then "Unpivot other columns".