How to replace the null value in rows?

RichardAlt

Hi guys,

How can I replace the null values with name.

I have 3 columns, ReportID, Name, and Amount.

As you can see in Name it has null value. I want to replace that with the name with same ReportID.

I want something like this. Same ID with same name.

*ReportID	*   Name	*   Amount
123	SAMPLE NAME1	123,000.00
123	SAMPLE NAME1	432,444.00
123	SAMPLE NAME1	554
123456	SAMPLE NAME2	787,676.00
123456	SAMPLE NAME2	2,345
123456	SAMPLE NAME2	234
1234	SAMPLE NAME3	143,435.00
1234	SAMPLE NAME3	123,412.00

deviseetharaman

Hi @RichardAlt 

Please use the Multirow formula tool. It should do in this case. Formula should be if !isnu

ll([Name]) then [Name] elseif [Row-1:ReportID] = [ReportID] then [Row-1:Name] else [Row+1:Name] endif