🔥 3-day streak
Microsoft Power BI Data Analyst83 / 205
Question 83 of 205

You import an Excel worksheet into Power Query where a 'Region' column contains a value only in the first row of each regional block (the source used merged cells for grouping). All other rows in each block show null for Region, even though they logically belong to the region named above. You need each row to carry its correct region value before loading. Which Power Query transformation should you apply to the Region column?

Reviewed for accuracy · Report an issueNext question