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?
mannerism
Highly Voted 2 years, 8 months agoGeetster
Most Recent 3 weeks, 4 days agoThejani
1 month, 1 week agoBP215
1 month, 2 weeks agoMirianeAn
2 months, 3 weeks agoKbo05
3 months agoIron_Jade
3 months, 3 weeks agoHosna2023
3 months, 3 weeks agoraavilam
4 months, 3 weeks agolucasnatanael93
4 months, 3 weeks agoHoooota
5 months, 2 weeks agoThandaPanda11
6 months, 3 weeks agoDexTorao
7 months agomv79
7 months, 1 week agoChopChop007
9 months agorcaliandro
10 months, 2 weeks agoKiran37
11 months ago