MultiRow Formula for Duplicate Values

[malves2011]

'm trying to use a multirow formula to add a character to the value of any prior row that is the same value as the next. Example listed below. Would like to add "xyz" each time there is another iteration of the same content in the "Value" column.

Record ID	Value	Revised
1	text1	text1
2	text1	text1xyz
3	text1	text1xyzxyz
4	text2	text2
5	text3	text3
6	text4	text4
7	text4	text4xyz
8	text5	text5
9	text6	text6
10	text7	text7

Thanks.

[Qiu]

@malves2011 

This one should work for you.

[grazitti_sapna]

Hi @malves2011,

Here is my take on your problem which is same as @Qiu.

.

I hope it helps.