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?