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.
0 kommentar(er)
