You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields:
- First name
- Last name
- Email address
- State/Region
- Phone number
You import the list into Power Query Editor.
You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.