Forum Discussion
Pivot Table Dates Columns
Hi all, Please see attached example sheet I have a table that has columns for countries, and retailers, and then it has columns for each month of sales they made. However I do not want to drag ...
Hi could you let me know if you are using Excel 2016 / 2013 or 2010?
Have you ever used Power Query, as it's perfect for this sort of thing.... (it's a free download for Excel 2010 and 2013, or built in to Excel 2016)
I even did a video on it recently showing how to "unpivot" dates so you can analyse it in a pivot table
https://www.linkedin.com/pulse/best-feature-excels-power-query-wyn-hopkins/
I'm using Excel 2013, I have never used PowerQuery but I will give that a try, thanks!
- Let me know how you get on