Copy Values to other column

[singh28ashish]

Hello,

I am trying to replicate below (Output field). I tried with multi row formula but no luck. Please help here.

Data:

Category	Value	Output
A	73	Null
A	23	73
A	57	23
B	22	Null
C	61	Null
C	26	61
D	63	Null
D	72	63
D	18	72

Thanks in advance!!

[binuacs · Accepted solution]

@singh28ashish One way of doing this with the multi-row tool formula

[grazitti_sapna · Accepted solution]

Hi @singh28ashish , you might have not selected the column for group by. I have highlighted the area where you might be mistaking.

[singh28ashish]

Thanks @binuacs, @grazitti_sapna for prompt reply. It worked.