•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Power Query to merge two tables
Our take
Power Query offers a powerful solution for merging data from multiple tables, enhancing your spreadsheet's functionality. In this scenario, you'll learn how to assign unique references from Table 2 to corresponding rows in Table 1 based on matching attributes—specifically Color, Temperature, and Shape. By effectively combining these datasets, you can streamline your data management process and improve overall productivity. This step-by-step guide will empower you to leverage Power Query for a seamless merging experience, transforming the way you handle your data.
| No. | Ref | Color | Temp | Shape |
|---|---|---|---|---|
| 1 | Black | Hot | Round | |
| 2 | Black | Hot | Round | |
| 3 | Black | Hot | Round | |
| 4 | Yellow | Warm | Round | |
| 5 | Yellow | Warm | Round | |
| 6 | Yellow | Warm | Round | |
| 7 | Green | Cold | Square | |
| 8 | Green | Cold | Square | |
| 9 | Green | Cold | Square |
| Ref | Color | Temp | Shape |
|---|---|---|---|
| 12859 | Black | Hot | Round |
| 12866 | Yellow | Warm | Round |
| 12871 | Green | Cold | Square |
| No. | Ref | Color | Temp | Shape |
|---|---|---|---|---|
| 1 | 12859 | Black | Hot | Round |
| 2 | Black | Hot | Round | |
| 3 | Black | Hot | Round | |
| 4 | 12866 | Yellow | Warm | Round |
| 5 | Yellow | Warm | Round | |
| 6 | Yellow | Warm | Round | |
| 7 | 12871 | Green | Cold | Square |
| 8 | Green | Cold | Square | |
| 9 | Green | Cold | Square |
Table 1 and Table 2 are my input tables, Table 3 is what I'm trying to achieve as an output. Essentially assign a unique reference in table 2 to a row within table 1where it finds a match (a match being Color, Temp and Shape agreeing).
[link] [comments]
Read on the original site
Open the publisher's page for the full experience