•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Power Query to merge two tables
| 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]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#row zero
#Excel alternatives for data analysis
#Excel alternatives