This situation happens a lot. Someone creates a pivot table based on some source data. They copy and paste it as...
How To Unpivot Data With Power Query
read more
About the Author
John MacDougall
John is a Microsoft MVP and qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.
Subscribe
Subscribe for awesome Microsoft Excel videos 😃
Articles from John MacDougall
How To Parameterize Your Power Query
When you create a power query in Excel to import or transform your data, Excel is creating the query behind the scenes...
How To Create A Hyperlink To The Current Workbook Folder
Example =HYPERLINK(LEFT(CELL("filename",C2),FIND("[",CELL("filename",C2))-2),"Click Here!") Download Example File...
Get the Latest Microsoft Excel Tips
Follow Us
Follow us to stay up to date with the latest in Microsoft Excel!
Subscribe for awesome Microsoft Excel videos 😃