Copying Values

[grsomer]

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?

[Thableaus · Accepted solution]

Hi @grsomer 

Use Multi-Row Formula Tool.

- Update Existing Field Option - Description

IF IsNull([Description]) THEN  [Row-1:Description]

ELSE [Description] ENDIF

Cheers,