Copy data from Above cell

[Inactive User]

Hi Team, 

I have a scenario where on Column A, if the cell is Null, I would like to copy data from above cell, Can someone help me with the same. 

I have attached the File with data and Expected results in 2 diff tabs 

[DataNath · Accepted solution]

Hey @Inactive User, you can do this with a Multi-Row Formula! If we use the following expression then we get your desired result:

IF ISNULL([Code]) THEN [Row-1:Code] ELSE [Code] ENDIF