Dataset with weeks as columns, need to pivot weeks into one column
How can i pivot a dataset which has the weeks as columns? I need to create one column with the weeks and the values within another column. This will enable me to provide charts more easily.
thanks for any ideas! i'm sure it's within redshift functionality, but i'm stuck.