Data cleaning

Question

Dear all,

As you can see in the picture below, I have one column which is filled by numbers and some cell are blanks. What I'm looking for is that I want each blank cell to be filled by the same number of the previous cell. For example row 3 and 4 should be filled by 2, 9 should be filled by 1.

sample.xlsx

Kenda · Accepted Answer

Hey @Feras95p

The Multi-Row Formula tool will be your friend in this case!

Simply select Update Existing Field at the top of the configuration window and select your Status field. Then use the following expression:

iif(isempty([Status]), [Row-1:Status], [Status])

Like this:

Hope this helps!