Refer to the exhibit.

One of the data sources a data architect must add for a newly developed app is an Excel spreadsheet. The Region field only was values for the first record for the region. The data architect must perform a transformation so that each row contains the correct Region.

Which function should the data architect implement to resolve this issue?