multi row , row +2 value

BRRLL99

Hi, i have following data set, using multi row formula , i want to get expected output, since i have multiple columns i dont want to use crosstab

Acc	NAME	SAF	ID
SA	100A
	100B	RM
		VA
DF	100D
	100F	RM
		VA

Expected output:

Acc	NAME	SAF	ID
SA	100A
	100B	RM	100B
		VA	100B
DF	100D
	100F	RM	100F
		VA	100F

ShankerV

Hi @BRRLL99 

Please use the below formula in Multi-Row formula.

It works as per your expected output.

IF Isempty([SAF])
THEN null()
ELSEIF Isempty([NAME])
THEN [Row-2:NAME]
ELSE [NAME]
ENDIF

Many thnaks

Shanker V