Hi!
I am working with a file that contains data and a column with descriptions in it. These descriptions are only populated on the first row of each of the same data input, however I would like them populated for all lines of the same data.
For example, description 1 is populated in row 2, description 2 is only populated in row 7, etc. I want description 1 to be copied from row 2 to row 6, description 2 to be copied from row 7 to row 11, etc.
Is there a way to do this?
Solved! Go to Solution.
Hi @grsomer
Use Multi-Row Formula Tool.
- Update Existing Field Option - Description
IF IsNull([Description]) THEN [Row-1:Description]
ELSE [Description] ENDIF
Cheers,