In this tutorial we’ll look at combining two different file types using Power Query to create a single table that we can then create a PivotTable from to do our analysis.
My previous video on combining like files in Power Query can be found here.
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 text file called Jan2017 containing sales data for that month:
I also have an Excel workbook called Feb2017 with a worksheet that contains this data:
Notice that, although similar, they are structured a bit differently. I want to be able to combine them into one table that I can use to create a PivotTable, like this:
Take a few minutes to watch the video and see how easy it is to accomplish this with Excel and 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!