Hello, I have two tables, the first table (Table 1) contains data populated from a database by using power query. The second table (Table 2) is just a directory for displaying data from Table 1 (currently empty). I read that you can dynamically link columns from different tables by setting up a relationship between the two tables instead of using vlookup. In power query I inserted a new column and made it an "index" column. In Table 2 I also created an index column, and then under the Data tab I created a new relationship using the index column in both tables. My question is, how do I link two columns in the tables so that a column in Table 2 is a mirror image of a column in table 1, and when I do a "Refresh All" the linked column in Table 2 gets updated.

Thanks