Forum Discussion
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...
Thank you for your help.
I tried your approach but it seems it did not gerenate the outcome I expected. I assumed the "created table" you referred is the one I unpivoted and applied list.repeat(). I ended up a table like below:
Howerver, the owner has agreed to change the column names with the exact date. So it is not an issue anymore.
Thank you!