Forum Discussion

bc2022's avatar
bc2022
Frequent Visitor
3 years ago

Transform a table and repalce value in column

Hello, I was wondering if anyone can help me to find a way to achieve this transformation. The raw data is as below. The day1, day2...day14 are dates for every two weeks, and this pattern will repea...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi bc2022 ,

 

Try using unpivot other columns.

Choose Role column and Shift column, click "Unpivot Other Columns".

You'll get the following data. 

Then you can separate out the days as the days of the date.

Hope that helps.

 

                                                                                                                                                         

Best Regards,

Stephen Tao

 

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

  • bc2022's avatar
    bc2022
    Frequent Visitor
    2 years ago

    Hi Anonymous ,

     

    Thank you for your suggestion.

     

    I did try the unpivot method before creating this topic. I think my problem at that time was how to repeatly convert day1..day14 to the exact dates in each month and quarter. 

     

    Thank you