Data cleaning

[Feras95p]

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.

 

[Kenda · Accepted solution]

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!

[Feras95p]

@Kenda Thank you ! it works great. I will add a new topic after 5 minutes please have a look into it I will be appreciated if you can help me in that topic. Many thanks again.