Forum Discussion
How to fill null values in column with previous non-empty value
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?
On the Transform tab in query editor, you can use Fill Down (or up) to get your result.
Pat
1 Reply
- mahoneypat
Microsoft Employee
On the Transform tab in query editor, you can use Fill Down (or up) to get your result.
Pat