need help

[Anonymous]

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.

[v-yangliu-msft]

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]

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