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, 7 months agoBP215
Most Recent 3 days, 11 hours agoMirianeAn
1 month agoKbo05
1 month, 2 weeks agoIron_Jade
2 months agoHosna2023
2 months, 1 week agoraavilam
3 months agolucasnatanael93
3 months agoHoooota
3 months, 4 weeks agoThandaPanda11
5 months, 1 week agoDexTorao
5 months, 2 weeks agomv79
5 months, 3 weeks agoChopChop007
7 months, 2 weeks agorcaliandro
8 months, 4 weeks agoKiran37
9 months, 2 weeks agoNishi_06
9 months, 4 weeks agoGrey_Head
1 year ago