Solved: Transpose multiple date columns into 1

Anonymous · ‎08-20-2021

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!

Mohammad_Refaei · ‎08-20-2021

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.

Mohammad_Refaei · ‎08-20-2021

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.

Anonymous · ‎08-21-2021

Thanks 😫 I have been working on this for Days

Transpose multiple date columns into 1