Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

need help

I need to pivot a column so that the data is linked to date and day, but all this data is in the same column.

 
Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi  Anonymous ,

     

    Here are the steps you can follow：

    1. In Power Query -- Add Column – Index Column – From 1.

    2. Select [Prod], [Segunda], [Tersa] – Transform – Unpivot Columns.

    3. Select [Index] – Transform – Pivot Column.

    4. Result:

    If it does not meet your expectations, can you express the results you want in the form of pictures, we can help you better.

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      mine is not the same as yours, what I need is similar to what you did, I need the dates to correspond to the data carried out and planned with the respective days. I really need help, this is for a interview for a job, if somebody want to help, i goin drop my dicord bellow

      Haroldo818#1604