How to fill null values in column with previous non-empty value

[Anonymous]

I have a column 'Resource' in a Table 'Resources', which looks like:

Resource

Chair

null

null

Fan

null

Desk

I want to populate this column, such that all null values are replaced with the non empty value before them. So the final output should look like:

Resource

Chair

Chair

Chair

Fan

Fan

Desk

How can I achieve this?

[mahoneypat · Accepted solution]

On the Transform tab in query editor, you can use Fill Down (or up) to get your result.

Pat