Forum Discussion
Solved
Dates in columns and variable
Currently, I have an input like below with hundreds of extra columns: Country ID Initiative Cost mar-21 apr-21 UK 1 1 100 30 40 US 2 2 150 12 11 IT 3 2 20 14 11 ...
That is a rather unfortunate table design. Have you considered unpivoting your month columns?
Unpivoting does the trick. Thank you!