How To Unpivot Data With Power Query
Get the files used in the video here:
http://www.howtoexcel.org/get-transfo...
This situation happens a lot. Someone creates a pivot table based on some source data. They copy and paste it as values and that becomes your new data source. But really you would have preferred the unpivoted source data.
Can you easily unpivot the data? Yes! 👇
Check out my full courses and ebooks here
👉 https://www.howtoexcel.org/courses/
DOWNLOAD the example workbook here
📖 https://www.howtoexcel.org/downloads/
SUBSCRIBE & get my 3 FREE eBooks
📧 https://www.howtoexcel.org/newsletter/
CONNECT with me on social
Facebook: / howtoexcelblog
Twitter: / howtoexcelblog
LinkedIn: / john-macdougall
Thanks for all your support!
