Summary of Excel Magic Trick 1412: Power Query to Merge Two Tables Into One Table for PivotTable Report

00:00:00 - 00:05:00

This video demonstrates how to use power query to merge two tables into one table for a pivot table report. The author shows how to select the two tables to be merged, eliminate any duplicate values, and create a column for the merged table. The video then shows how to close the queries in connection and create a regional sales report from the merged table.

• 00:00:00 In this video, the presenter demonstrates how to use power query to merge two tables into one table for a pivot table report. First, they convert the two tables to Excel tables using the table button or ctrl T. Next, they name the table D sales rep and enter. Finally, they use the merge feature in the data ribbon to combine the two tables into a single table. The new column will contain the region values for each record in the D sales rep table.
• 00:05:00 In this video, the author shows how to use power query to merge two tables into one table for a pivot table report. First, the author selects the two tables to be merged. If there are any duplicate values, the author eliminates them using backspace and enters "now." Next, the author double clicks the backspace key to enter data and creates a column for the merged table. Finally, the author closes the queries in connection and creates a regional sales report from the merged table.