Forum Discussion
Columns into cells
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
You can do that in the query editor by selecting all but your date columns, right clicking, and choosing "Unpivot Other Columns".
Pat
1 Reply
You can do that in the query editor by selecting all but your date columns, right clicking, and choosing "Unpivot Other Columns".
Pat