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 · Accepted solution]

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

[aatalai]

Also make sure you set the number of rows to 2

[BRRLL99]

there is slight change in my original data

Acc	NAME	SAF
SA	100A-98786-99
	100B-12345-00
		RM
		VA
DF	100D-32190-88
	100F-33333-00
		RM
		VA

[binuacs]

@BRRLL99 

[BRRLL99]

thank you for your reply
is it possible with only one multi row formula?

instead of using multiple tools

[binuacs · Accepted solution]

@BRRLL99