Forum Discussion
Table Transfrom
Hi! Can you help me transform the table below to show the start and end date to be the columns? Thank you! I tried transform and unpivot but I cant seem to get it.
Cheers!
Hi,
In the Query Editor, click on any cell in the Date type column and under Transform, click on the Pivot button. In the drop down, select Date. Expand the Options triangle and select Don't aggregate.
Hope this helps.
4 Replies
Hi,
In the Query Editor, click on any cell in the Date type column and under Transform, click on the Pivot button. In the drop down, select Date. Expand the Options triangle and select Don't aggregate.
Hope this helps.
You are welcome.
Anonymous , Pivot Date Type and Date
