Originally I would have edited each query, selected the Acct and Dept columns, and merged the two columns together, probably separating them with a custom delimiter. Now, with both of those created, I want to merge the data so I get the account name on each row of the Transactions table. Select a cell in the right table (COA) –> create a new query –> From Table –> Close & Load To… Connection only.Select a cell in the left table (Transactions) –> create a new query –> From Table –> Close & Load To… Connection only.To get started, I created two connection only queries, one to each table. (Elsewhere in the data the same account exists in multiple departments. The problem is that the unique key to join these two tables (which isn’t super obvious here) is a combination of the Acct and Dept fields. There’s two tables, and we want to join the account name to the transaction. The IssueĪssume for a second that we have data that looks like this: During that session, Reza showed a cool trick to merge data based on two columns through the user interface… without concatenating the columns first. While I was there, I attended Reza Rad’s session on Advanced Data Transformations with Power Query. This past weekend I attended SQL Saturday in Portland, OR.

Merge duplicate rows in excel 2013