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 m the Customer table. Each Address ID represents a unique address m 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?
Submit