Managing Data With Power Query In Excel

In this tutorial we’ll take a look at several features in Power Query that help you manage poorly structured data, and put it in a format to best use it with tools such as PivotTables.

In previous posts I’ve looked at Power Query to unpivot columns, and merging files, those posts are listed here:
http://www.excel-bytes.com/how-to-unpivot-data-using-power-query-in-excel/
http://www.excel-bytes.com/how-to-combine-files-using-power-query-in-excel/

I am using Excel 2016 in this tutorial which has Power Query built into the Data tab. Here is also a link to add Power Query to Excel 2010 and 2013:

https://www.microsoft.com/en-us/download/details.aspx?id=39379

You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.

Here I have a data set with various sales information:

I want to convert it to a table such as this:

So I can use it to create a PivotTable and analyze it better like this:

Take a few minutes to watch the video and see how easy it is to do with Power Query!

What can you do next?
Share this post with others that can benefit from it!
Leave a comment or reply below – let me know what you think!
Subscribe to this blog for more great tips in the future!
Check out my YouTube channel – click on the YouTube icon below!

Happy Excelling!

Related Post

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

, , , , , ,

No comments yet.

Leave a Reply