Q34
Hotspot
HOTSPOT
You use Power Query Editor to review the query shown in the following exhibit.
Each Region value appears only on the row where it first occurred. Each subsequent occurrence of the Region value is blank.
You need to ensure that every row contains the correct non-blank value. The solution must minimize development effort.
Which column should you select, and which action should you perform on the column? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Select the correct area(s) on the image.
