Question
You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns:
- Customer ID
- Customer Name
- Phone
- Email Address
- Address ID
Address contains the following columns:
- Address ID
- Address Line 1
- Address Line 2
- City
- State/Region
- Country
- Postal Code
Each Customer ID represents a unique customer in the Customer table. Each Address ID represents a unique address in the Address table.
You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer.
What should you do?
- A. Merge the Customer and Address tables. Correct
- B. Group the Customer and Address tables by the Address ID column.
- C. Transpose the Customer and Address tables.
- D. Append the Customer and Address tables.
Explanation
A merge joins Customer to Address on Address ID, keeping one row per customer and letting you expand City, State/Region, and Country into it. Appending stacks rows from both tables instead of adding columns. Grouping aggregates rows, and transposing swaps rows and columns, so neither combines the two tables.
