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?
Currently there are no comments in this discussion, be the first to comment!