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

v-yuta-msft's avatar
v-yuta-msft
Community Support
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