power query for excel 2013 free download

Or if you’re a VBA whiz, you can write a code to do this.īut these options are time-consuming and complicated as compared with Power Query. Now you can rely on VLOOKUP or INDEX/MATCH to do this. You’ll have to map the relevant records from Table 1 with data from Table 2 and 3.

To get all this information into a single table, you will have to merge these three tables so that you can then create a Pivot Table and analyze it, or use it for other reporting/dashboarding purposes.Īnd by merging, I don’t mean a simple copy paste. This information is provided as separate tables as shown below: This table has the data I want to use, but it’s still missing two important columns – the ‘Product Id’ and the ‘Region’ where the sales rep operates. In case you prefer reading the text over watching a video, below are the written instructions. One of the things where Power Query can save you a lot of time is when you have to merge tables with different sizes and columns based on a matching column.īelow is a video where I show exactly how to merge tables in Excel using Power Query.

With Power Query, working with data dispersed across worksheets or even workbooks has become easier.

Power query for excel 2013 free download