'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.
