Forum Discussion
Transpose multiple date columns into 1
Hi! I am making a dashboard for a projects and need some help transposing some columns.
I have a sample File Here // In the sample file there is a sheet for the current state and a seperate sheet for the future (desired) state.
The Over all goal is transform multiple date columns into 1 date column to be used in visualizations.
Thanks!
In the Query Editor, select the date columns and in Transform tab choose Unpivot.
This will give you exactly what you want.
Please check this sample file.
2 Replies
In the Query Editor, select the date columns and in Transform tab choose Unpivot.
This will give you exactly what you want.
Please check this sample file.