Columns into cells

[Anonymous]

Hi Everybody,

Need some help in transforming Nintendo Shop Digital Sales raw data into a format that its helpful.
The original raw data looks like this with a long list of columns for each available day.
Do you have any suggestion to make it into a conventional format like the below?
Thanks M

[mahoneypat · Accepted solution]

You can do that in the query editor by selecting all but your date columns, right clicking, and choosing "Unpivot Other Columns".

Pat